Referencing a pivot tables Grand Totals Column

G

glen

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
 
G

glen

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
Click to expand...

I should say I am using Excel 2003
Thanks for any help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Column Totals - XL2003 5
Dealing with a Pivot Table (when I don't want to) 0
Grand Total for Rows not Working in a Pivot Table 1
Grand Totals for Pivot Tables 4
Pivot table row grand totals 0
How do I perform extended calculations in a Pivot Table in Excel 2 4
Pivot Table - move Totals column 1
Pivot Table Grand Total 3

Top