Using Change Tracking with a Pivot Table

[mctithof]

I need to track changes to an Excel spreadsheet that has a pivot table. I know that the tracking functionality in Excel requires that the workbook be shared, but the pivot tables cannot be used in a shared workbook. But, whenever I unshare the workbook to update the pivot table, the tracking history is lost. What I would like to do is automatically copy the "History" worksheet to an archive whever sharing is turned off so that it is not lost. Any ideas on this?

Thanks.

 

[mctithof]

Anybody with any thoughts out there. This problem is quite frustating!