Forum Discussion
Custom VIews--menu selection is grayed out-
I have a spreadsheet in which I'd like to create a Custom View, but that option is grayed out on the menu and toolbar. It appears on some other (most other) workbooks I have. I've not been able to find an explanation in Excel Help for why in this case it would not appear as well.
It IS a workbook stored on OneDrive and shared with another person. That's a distinctive feature in this case; the only one I can think of.
If you have data in a Table on any worksheet, then the Custom Views is not available.
17 Replies
mathetes so if you are trying to import the data into SQL, and you have "other data" on the sheet, using a custom view was a way to do this, however, as mentioned if tables exist you can't also use custom views, so what is the answer to then importing to SQL without the ability to use them...as the WHOLE sheet is not an option....
Jason
- I've never imported data into SQL so really can't even begin to answer your question. May I suggest that you start a new thread on the main board with a description of your situation, the task or goal, and your question. That will enlist the help of others who may have dealt with importing into SQL
If you have data in a Table on any worksheet, then the Custom Views is not available.
- Hello Alan Murray
I have not any data on any other worksheet, even after that , custom views is not working. Thanks. I never knew....and couldn't find a reference in Help that pointed in the direction of anything like that.
Fortunately I ended up being able to skin this particular cat another way, thanks to all the many ways Excel offers. And what I did was probably more effective any way. But oh, my, I have Tables in most of my workbooks, so I guess Custom View may become a thing of the past.
Hi,
could you pl share on what is that you have done as alternative to custom view with Table formats present in Excel. It will be of help to me, as i too have the same issue.
thanks
sadasivam73
