View Full Version : Pivot Table reference changing

2016-11-29, 04:07 PM
@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

2017-01-02, 02:55 PM
did anybody know the problem? I have the same issue on some not others.