Forum home » Delegate support and help forum » Microsoft Excel Training and help » 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. |
Custom views
Resolved · High Priority · Version 2003
Reply Tue 8 Jul 2008, 11:14Delegate Liz said...
Liz has attended:
SharePoint course
Custom views
We have a template with custom views.
We want to create other similar worksheets within the same workbook, and we'd like the custom views to apply the same filters, etc. but in the new worksheet.
We find that by using copy sheet, applying the custom view displays the original worksheet. Is there a solution please?
For upcoming training course dates see: Pricing & availability
RE: custom views
Hi Liz,
Thank you for your post: To my knowledge Custom Views is only available on the worksheet on which it was created, therefore any custom views that are invoked on another worksheet even though a copy will always point to and open on the original worksheet. (As you have discovered).
Sadly there is no workround available. You will have to re-create the custom views for each new worksheet. Pete
|