GetpivotData returns a #REF! error

G

Guest

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?
 
D

Debra Dalgleish

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?
 
G

Guest

I found the issue, just not sure why it's popped up or how to fix it. In the
formula below if the Haberfeld!G6 cell is text, the formula works, but does
not if this cell is numeric. Any suggestions?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top