Archive pivot tables

[opislak]

Hi all,

Is there a way to prevent users from refreshing pivot data?

I have pivot tables looking up data through ODataFeed. After 2 years, the original data is being erased from the servers, but we have to keep all the pivot tables (managers do ask us to compare data from -say- 5 years ago with today's data). I now keep the pivot tables and put a Warning on top, asking the users NOT to refresh the data (for if they do, the table is cleared of course). I store an original copy of the Excel files in case someone would still erase the data by refreshing. But that doesn't seem like a neath thing to do.

Any advise is welcome. Thanks for your replies.
Patrick.

 

[BSALV]

The best way is (manually or with VBA) copy the whole pivottable and paste it special as values and add good comments.
Of course you loose the ability for showdetails etc.

But if you also keep the data over those +5 years, and those data from 5 years aren't modified, with some slicers you can create the old pivottable again. You can you which year or years, you want the data ...

 

[opislak]

The best way is (manually or with VBA) copy the whole pivottable and paste it special as values and add good comments.
Of course you loose the ability for showdetails etc.

But if you also keep the data over those +5 years, and those data from 5 years aren't modified, with some slicers you can create the old pivottable again. You can you which year or years, you want the data ...

Thanks. Works fine.