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 |
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. |
All times are GMT +1. The time now is 09:39 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com