Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pivot tables Excel 2003 absolute references
I've just installed office 2003. I use piovt tables a lot. Before I could use
an existing pivot table in formulas outside the table itself with great ease. But now, everytime I create a formula outside the pivot table all references are absolute and is full of no use formulas (like Get.Pivotdata(...). Only with a lot of work I can go around this new "feature" in excel 2003. Is there a way to solve this? |
#2
|
|||
|
|||
"Poj" wrote: I've just installed office 2003. I use piovt tables a lot. Before I could use an existing pivot table in formulas outside the table itself with great ease. But now, everytime I create a formula outside the pivot table all references are absolute and is full of no use formulas (like Get.Pivotdata(...). Only with a lot of work I can go around this new "feature" in excel 2003. Is there a way to solve this? You can get the old formulas by typing the cell references directly, rather than clicking on the cells you want to reference. E.g., if B5 is in the pivot table, and you want to use its value in a formula in D5 (which is outside the pivot table), go to D5 and type "=B5...", rather than "=" followed by a mouse click on B5. |
#3
|
|||
|
|||
You need to turn this feature off (or on) with the Generate GetPivotData
button. There are instructions here for adding the Generate GetPivotData button to a toolbar, and toggling the feature on and off: http://www.contextures.com/xlPivot06.html "Poj" wrote: I've just installed office 2003. I use piovt tables a lot. Before I could use an existing pivot table in formulas outside the table itself with great ease. But now, everytime I create a formula outside the pivot table all references are absolute and is full of no use formulas (like Get.Pivotdata(...). Only with a lot of work I can go around this new "feature" in excel 2003. Is there a way to solve this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
Printing a Pivot Table from code - Excel 2003 | Excel Discussion (Misc queries) | |||
How do I fix column widths in Excel Pivot Tables? | Excel Discussion (Misc queries) | |||
Referring to Pivot Table in Excel 2003 | Excel Worksheet Functions |