ExcelBanter - Custom View Grayed Out

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Custom View Grayed Out (https://www.excelbanter.com/excel-discussion-misc-queries/188302-custom-view-grayed-out.html)

Mike H.

Custom View Grayed Out

I have a 2007 excel book and custom view icon is grayed out. I saved it from
being a 2003 .xls file. I can't get it "ungrayed". Ideas?

malcomio

Custom View Grayed Out

I have the same problem and I really can't figure it out. I opened a new
workbook, copied the sheet I wanted into it, and the custom view option was
unavailable.

That sheet has a table on - could that be something to do with it?

Rachel[_4_]

Custom View Grayed Out

Yes, if you have defined an excel table anywhere in the workbook, the
custom views option will be unavailable ... if you convert the tables
to normal ranges, custom views will be available.

All times are GMT +1. The time now is 12:25 PM.