Forum Discussion
Solved
Custom VIews--menu selection is grayed out-
I have a spreadsheet in which I'd like to create a Custom View, but that option is grayed out on the menu and toolbar. It appears on some other (most other) workbooks I have. I've not been able to f...
If you have data in a Table on any worksheet, then the Custom Views is not available.
Thanks. I never knew....and couldn't find a reference in Help that pointed in the direction of anything like that.
Fortunately I ended up being able to skin this particular cat another way, thanks to all the many ways Excel offers. And what I did was probably more effective any way. But oh, my, I have Tables in most of my workbooks, so I guess Custom View may become a thing of the past.
I think you are right there. Formatting data in a table is very useful so Custom Views is as you say now 'a thing of the past'.
Nice work buddy.