Forum home » Delegate support and help forum » Microsoft Excel Training and help » Enabling custom views
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Enabling custom views
Resolved · Urgent Priority · Version 2003
Reply Tue 2 Jun 2009, 11:15Delegate Liz said...
Liz has attended:
SharePoint course
Enabling custom views
Custom views is disabled and I don't know why, what causes this please?
For upcoming training course dates see: Pricing & availability
RE: Enabling custom views
Hi Liz
Thank you for your question. You might want to check to see if there is an Excel list in your workbook. If there is it will disable Custom views for the whole workbook.
Let us know if you have any further questions.
Kind regards,
Andrew
Reply Wed 3 Jun 2009, 11:36Delegate Liz said...
RE: Enabling custom views
There is a list. How do I get rid of it please?
RE: Enabling custom views
Hi Liz
To remove the list click in the list and convert it to a named range by going to Data > List > Convert to named range. At the prompt choose Yes to convert to a normal range. You should then find Custom Views is enabled.
I hope this helps.
Kind regards,
Andrew
RE: Enabling custom views
Hi Liz,
Thank you for your question.
After doing some testing and research, if you use the Create List command from the Data menu on existing data, it disables the Custom Views for all the worksheets in the workbook.
If this is the case you can convert the list back to a range by navigating to Data, then List and Convert to range. This should enable the Custom views.
I hope this answers your question.
Regards
Simon
|