Pivot Table reference changing

Corrado

New member
Joined
Nov 29, 2016
Messages
1
Reaction score
0
Points
0
@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
 
Last edited by a moderator:
did anybody know the problem? I have the same issue on some not others.
 
Back
Top