@golfnfryguy I'm having the same problem and it's driving me insane.
I have a dynamic name range*, "pivot data", which I use as the data source for a pivot table. * =data!$A$1:INDEX(data!$A:$AE,COUNTA(data!$A:$A),COUNTA(data!$1:$1))
If I change the name from "report 24/11/16" to "report 25/11/16", the pivot will refer to "'report 24/11/16.xlsx'!pivot data" instead of just "pivot data" (or "'report 25/11/16.xlsx'!pivot data" )
The particularly galling part is that I have some reports that don't have this problem at all; they keep a local reference ("Pivot data") after the name of the workbook is changed. I can't see any difference between the two workbooks that would account for this.
Edit Mod : Post related to http://www.excelguru.ca/forums/showthread.php?6333-Change-in-data-source
I have a dynamic name range*, "pivot data", which I use as the data source for a pivot table. * =data!$A$1:INDEX(data!$A:$AE,COUNTA(data!$A:$A),COUNTA(data!$1:$1))
If I change the name from "report 24/11/16" to "report 25/11/16", the pivot will refer to "'report 24/11/16.xlsx'!pivot data" instead of just "pivot data" (or "'report 25/11/16.xlsx'!pivot data" )
The particularly galling part is that I have some reports that don't have this problem at all; they keep a local reference ("Pivot data") after the name of the workbook is changed. I can't see any difference between the two workbooks that would account for this.
Edit Mod : Post related to http://www.excelguru.ca/forums/showthread.php?6333-Change-in-data-source
Last edited by a moderator: