View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Debra Dalgleish
 
Posts: n/a
Default GetpivotData returns a #REF! error

What version of Excel are you using?
What's the GetPivotData formula?
What was the file name previously, and what is the new file name?

Jeff K wrote:
I have a monthly file with getpivotdata formulas which I resave each month as
a different name. All of the sudden on the most recent resave, my
getpivotdata formulas no longer work, with absolutely no changes to the file
other than the filename. Any suggestions out there?




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html