Enabling custom views

Hi Liz

Thank you for your question. You might want to check to see if there is an Excel list in your workbook. If there is it will disable Custom views for the whole workbook.

Let us know if you have any further questions.
Kind regards,
Andrew

Hi Liz,

Thank you for your question.

After doing some testing and research, if you use the Create List command from the Data menu on existing data, it disables the Custom Views for all the worksheets in the workbook.

If this is the case you can convert the list back to a range by navigating to Data, then List and Convert to range. This should enable the Custom views.

I hope this answers your question.

Regards

Simon