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?
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
