getpivotdata

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
 
D

Debra Dalgleish

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.
 

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