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

Hi Lee

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

help?

cheers
JulieD

"Lee" wrote in message
...
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

Julie

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

Lee


-----Original Message-----
Hi Lee

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

help?

cheers
JulieD

"Lee" wrote in
message
...
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


.

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

Cheers
JulieD

"Lee" wrote in message
...
Julie

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

Lee


-----Original Message-----
Hi Lee

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

help?

cheers
JulieD

"Lee" wrote in
message
...
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


.