GETPIVOTDATA Reference

S

ScottS

Hello All,

Is it possible to use a cell reference for the Data_Field argument of the
GETPIVOTDATA function? I keep getting the #REF! error when I try this.

Thanks in advance for any help on this.
 
S

ScottS

Thanks for the help. I have used references for some time now but have run
into a problem with this particular spreadsheet. I have cell references in
place for the other references that work just fine, but the the Data_Field
argument will not work when I replace the text entry in the function with a
cell reference.

I'll keep working on it.
 
S

ScottS

Herbert

Sorry for the extended delay in a reply -- thanks for this excellent
solution! I was running into problems using a reference for the data field
in my getpivotdata formula and using the TEXT function took care of it.
 

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