I have a worksheet where I use pivot tables to sort data. Each day a new tab is started using the move/copy function. The worksheet is updated and thats where the fun begins. Prior to July 5 I would go to analyse and change the date to correspond with the new date and the spreadsheet would update. In earlier versions of the spreadsheet there were no connections nor tables. Since July 5 when I go to update the pivot tables the pivot tables revert to an earlier date or refuse to update.
When I now delete the pivot table and start afresh and do the move copy and try to update, either the pivot table disappears and wants me to add the link or it says it cannot find the file on my c drive.
When I start a completely new worksheet with nothing copied across I still have the same issue.
I think it is a connection issue, but I am not sure. The new spreadsheet has under tables several tables which are somewhat puzzling. Obviously in my attempt to fix the problem I have created others.
If anyone has an answer I would love to hear the solution.
Cheers
