Hello--I have a very basic pivot table that counts the number of time
an item is a spreadsheet. I would like to write formulas outside of
the pivot table that calculate the average of all of the items, as
well as the standard deviation. The only problem is that, when I
modify the spreadsheet feeding the pivot table and refresh it, the
ranges in my formulas are no longer correct. Is there a way to make
these ranges update automatically when the pivot is refreshed? Or,
should I just do this manually everyday? Thanks for the help!