| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Referencing a pivot tables Grand Totals Column
I have a pivot table that has a Grand Totals Column. I am trying to
reference that complete column in another sheet. (I do some Countif & Sumif Formulas on that column) Everything works fine until the source data changes and the pivot gets updated, which either shrinks or enlarges the pivot table. When this happens my links to the Grand Totals Column aren’t valid anymore. How do I accommodate for this occurrence. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Referencing a pivot tables Grand Totals Column
On Jun 20, 12:03*pm, glen wrote:
I have a pivot table that has a Grand Totals Column. I am trying to reference that complete column in another sheet. (I do some Countif & Sumif Formulas on that column) Everything works fine until the source data changes and the pivot gets updated, which either shrinks or enlarges the pivot table. When this happens my links to the Grand Totals Column aren’t valid anymore. How do I accommodate for this occurrence. Thanks I should say I am using Excel 2003 Thanks for any help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Row Grand Totals in Pivot Tables? | Charts and Charting in Excel | |||
| Grand Totals for Pivot Tables | Excel Discussion (Misc queries) | |||
| Pivot Totals: Group totals different from Grand totals | Excel Discussion (Misc queries) | |||
| Pivot Tables - Grand Totals | Excel Discussion (Misc queries) | |||
| Excel - how do I show column grand totals on the pivot chart | Charts and Charting in Excel | |||
Linear Mode
