custom views

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Custom views

Custom views

resolvedResolved · High Priority · Version 2003

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?

Edited on Thu 10 Jul 2008, 08:10

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

 

Training courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Adding cells, Rows & columns

place your cursor on a cell, row number or column letter and use CTRL + SHIFT + + or CTRL + + depending on which + you prefer to use.

View all Excel hints and tips


Server loaded in 0.08 secs.