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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SmartArt greyed out 0
How to Create an S-Curve from Custom Field? 0
Is it possible to edit colours already saved as part of a custom theme? 0
Read Only now different 1
MS Project Center-Autolink column fields 0
Can't close old pst file 2
Table of content - format does not get saved 2
Need some PWA help 0

Top