GETPIVOTDATA General
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
|