GetPivotData function

G

Gary

I set up a spreadsheet in Excel 2002 using the
GetPivotData function. Now I need to utilize the same
function in Excel 2000 but it does not seem to have the
same power. Does anyone know if there is a way to utilize
the GetPivotData function in Excel 2000 to reference
multiple fields (5) in a pivot table?
 
D

Debra Dalgleish

In Excel 2002, the GetPivotData formula may be created automatically,
when you reference a cell in the PivotTable.

You can manually create a GetPivotData formula in Excel 2000, and its
arguments are different than those in Excel 2002. Look in Excel's Help
files for information and examples.
 

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

Use cell_ref in place of an item in get pivot data function 2
Excel 2007 GetPivotData Function 2
GETPIVOTDATA 3
GetPivotData Multiple Fields 6
Problem with getpivotdata function 1
getpivotdata 1
GETPIVOTDATA #REF! error XL2003/2010 1
Pivot Table with Data Model Connection - getpivotdata #REF error 0

Top