Hi All,
I have a report I run weekly which is a workbook with many sheets and a large number of pivot tables. Each week I save out the old workbook with the new date, update the export tab which all the pivots pull from, refresh the pivots and then save. For some reason this week I am getting an error that one of the pivot tables is not working because it can't update the source file. This is the first time I have gotten this error and nothing has changed within the workbook. To make things even more confusing this error is referencing a very old file that hasn't been used and when I have gone through and checked every single pivot table multiple times they are all properly linking to the export tab within the workbook, even on hidden tabs. I simply can not find the source of this issue to fix as every pivot is properly linked and nothing seems to be linking back to this old random file. Any help would be greatly appreciated!!
Bookmarks