Detach Sheet copy from its original

[#1]

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

[MayilVahanan · Accepted solution]

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.

[#3]

Thank you