getpivotdata

  • Thread starter Thread starter Dion
  • Start date Start date
D

Dion

Hi
I have a problem
When, using Excel 2000, i make a reference to a cell inside a pivot
table, excel puts a function like "=f5"
when i do the same operation in Excel Xp or Excel 2003, the application
insert a function named getpivotdata.
I understand what this function does but i want to know if there is any
option to choose what function must excel enter when i do this
reference.

Thanks
 
In Excel 2002, a GETPIVOTDATA formula is automatically created when you
link to a cell in a pivot table.

You can choose Tools>Customize, and from the Data category on the
Commands tab, add the Generate GetPivotData command to one of your
toolbars. Use this button to toggle the feature on and off.

Or, you can type an equal sign, and type the cell reference, instead of
clicking on the cell to reference it.
 
Back
Top