Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 471
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 15
Default 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?
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Custom View Me Excel Worksheet Functions 0 March 13th 07 06:42 PM
View Custom View with Sheet Protection John H[_2_] New Users to Excel 1 February 16th 07 05:54 PM
How to view a custom view when the worksheet is protected? JulesJam Excel Worksheet Functions 0 March 6th 06 02:15 PM
Missing "Custom View" entry from View menu mycroft777 Excel Discussion (Misc queries) 1 February 3rd 06 05:33 PM
Custom Views Grayed Out Wayne @Micros Excel Worksheet Functions 0 April 28th 05 12:50 PM


All times are GMT +1. The time now is 07:30 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"