create pivot table formula without the GETPIVOTDATA function

G

Guest

Previous to Excel 2003 I could use a pivot table result in a formula and copy
that formula as a relative reference. In Excel 2003 a GETPIVOTDATA fromula
is created and uses an absolute reference. Is there a way in Excel 2003 to
either make it arelative reference (without editing the formula) or revert to
the method used in all prior releases?
 
G

Guest

After posting I saw reference to your site and found the answer there - great
site. Thank you!
 

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

Similar Threads

2003 formula for Pivot 1
Use cell_ref in place of an item in get pivot data function 2
how to refer the cell insteat of Getpivotdata in excel 2003? 1
GETPIVOTDATA in Excel 2007 2
Problem with getpivotdata function 1
Pivot Table with Data Model Connection - getpivotdata #REF error 0
Pivot Table with Data Model Connection - getpivotdata reference issue 0
GetPivotData and cell references 2

Top