Pivot table in excel 2007 not updating automatically
I have a pivot table in an excel 2007 file set to “Refresh data when opening the file”
However when I open the file I have to Refresh the Pivot table manually.
Any ideas how I can get this option to work ?
Oh...and i thought all i had to do was tick the box
produces the results
roryo...it links directly to a range on another tab