Custom View Grayed Out

M

Mike H.

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?
 
M

malcomio

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?
 
R

Rachel

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.
 
Top