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.
Thanks.