Forum Discussion
How do I Save a Specific Filter within a DataBase
I have a table of data with headers. I can Sort this data, and I can filter this data. What I would like to do is save a particular system of filtering this data, so that I can recall or re-use it ...
If Custom Views no longer work with structured tables then is there a way to save specific sort/filter operations like Custom Views formerly did?
I would like to not have to go step by step rebuilding my sort/filter (Query?) process each time I have altered my data table.
PS: thanks for your response and help
Custom Views never worked with structured tables, and it didn't work with Lists which was introduced before tables long ago.
If we speak only about sorting/filtering you may use Sheet Views Sheet Views in Excel (microsoft.com) if file is kept online (on SharePoint/OneDrive).
- With all due respect, I viewed a video that clearly showed, mentioned, and discussed using Custom Views with Tables. Apparently, it was an earlier version, perhaps several versions earlier, but I would hesitate from saying Custom Views never worked with Tables. I can provide the video name and the time within the video when such a reference was made.
I will explore the Sheet Views option.
Again, thank you for your help.KSNelson1 I appreciate if you give the reference, will be very sorry then.
- https://youtu.be/5DwKhLVnMEg at 10:42
(This should be a video titled "Excel Database Part 1 - How to Use Excel as a database - Excel 2010, 2013, 2016 database tutorial")