I have learned that I can use "Sheet Library" to embed a sheet in my Stories. However I find the content of the sheet in my Stories stay with the filter I applied before I embedded it. When I change the filter in the actual sheet, it doesn't change the content of the same sheet in my Stories, and once I open the sheet in my Stories, it will revert back to the old filter content, and also change the filter accordingly in the actual sheet.
What I am trying to achieve is, to set up a Story with embedded sheet, so that every month I can go to the actual sheet and change the filter to the latest month, then the Story get automatically updated and I can export it to a pptx.
How can I do it?
Thanks in advance!