Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

1 Solution

Accepted Solutions
MayilVahanan

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.

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

2 Replies
MayilVahanan

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.

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

Thank you