Custom View Grayed Out in Excel

[ninfan]

Has anyone encountered an issue in Excel where the "Custom Views" selection under the "View" menu is grayed out? It seems to be worksheet-specific because it is available on other worksheets I use.

Any help would be greatly appreciated.

Troy

 

[xlhelp]

Are two or more worksheets grouped together? Try right clicking on a sheet and choose ungroup.

Member AAA - Abolish Abused Abbreviations

 

[xlhelp]

Also, if anything has changed under Tools, Options, View; such as Gridlines, Color etc, you will get the same kind of problems.

And..... this from XL Help

Note You cannot create a custom view when a worksheet contains an Excel list (list: A series of rows that contains related data or a series of rows that you designate to function as a datasheet by using the Create List command.). If one or more worksheets contain an Excel list, the Custom Views command is disabled for the entire workbook.



Member AAA - Abolish Abused Abbreviations

 

[ninfan]

Thank you for the replies. Interestingly enough, I have both grouping and Excel lists being used in this workbook. There are several worksheets in the workbook and it seems that Custom Views are not allowed on all worksheets if any of them involve grouping or lists.

Thank you for the quick responses!

Troy