GETPIVOTDATA General

[Lee]

We have recently moved to Excel 2003 from Excel 2000. I
create numerous pivot tables, then outside the pivot
table, use the pivot data, to create summaries, totals,
etc. What is happening now is, instead of just linking to
a cell in the pivot table, it also links to a formula.

For example: On a Pivot table that I calculate effective
fee the formula was: (M5-K5)/K5. Each of these cells is
in the pivot table, the effective fee formula is outside
of the pivot table.

The formula now is =(GETPIVOTDATA(" Grnd
Total",$A$3,"ResourceID","FDDT","TASK
ID","03","DESCRIPTION","Bid C.E. Foor FY05")-GETPIVOTDATA
(" Total Cost",$A$3,"ResourceID","FD01","TASK
ID","04","DESCRIPTION","Actual C.E. Foor
FY05"))/GETPIVOTDATA(" Total
Cost",$A$3,"ResourceID","FD01","TASK
ID","04","DESCRIPTION","Actual C.E. Foor FY05")

This ties the cells outside the pivot table to very
specific items and I haven't found a way to update the
pivot table (change the name of a resource ID), or copy
the cells outside of the table, and have the cells update.

I know I haven't explained this well, but is there any way
to shut this "feature" off.

Thanks,

Lee

 

[JulieD]

Hi Lee

does
http://www.contextures.com/xlPivot06.html

help?

cheers
JulieD

 

[Lee]

Julie

THANK YOU!! The default setting on this "feature" has
caused my coworkers and I major frustration.

Lee

 

[JulieD]

you're welcome .. Debra's site has heaps of great info on it ... suggest you
keep it bookmarked.

Cheers
JulieD