Forum Discussion
How do I Save a Specific Filter within a DataBase
Yes, Custom View doesn't work with structured tables, that's directly mentioned in support page Create, apply, or delete a custom view (microsoft.com)
Why so - philosophic question, you may check discussions like this Custom VIews--menu selection is grayed out- - Microsoft Tech Community
- KSNelson1Sep 30, 2021Copper Contributor
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
- SergeiBaklanSep 30, 2021Diamond Contributor
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).
- KSNelson1Oct 07, 2021Copper ContributorWith 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.