
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Detach Sheet copy from its original
Hi ,
I have a sheet with several filters and one pivot table and I woould like to preserve the whole sheet as it is rigth now.
In order to change the filter values I made a copy of the original sheet but it makes changes in the original which, as I said, I don't want to change.
How can I detach a copy of a sheet with all its objects, from the original one?.
Thanks
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi
Create a alternate state from the document properties -> general -> alternate state -> add and give name to it.
Then ,go to the sheet, which you must use like detach, then sheet properties -> general -> use that alternate that ..
Hope it helps.
Please close the thread by marking correct answer & give likes if you like the post.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi
Create a alternate state from the document properties -> general -> alternate state -> add and give name to it.
Then ,go to the sheet, which you must use like detach, then sheet properties -> general -> use that alternate that ..
Hope it helps.
Please close the thread by marking correct answer & give likes if you like the post.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you
