Number of posts : 5 Location : Bentonville Company : US Nutrition Title : Category Development Registration date : 2008-05-08
Subject: Excel Cell References Not Updating Mon Mar 02, 2009 3:42 pm
I have cell references that are linked back to another Excel Pivot Table. The problem is when I refresh my pivot table the cell references do not change values to reflect the new pivot table data. Any ideas on what could be causing this and the remedy?
jmiller
Number of posts : 5 Location : Bentonville Company : US Nutrition Title : Category Development Registration date : 2008-05-08
Subject: Re: Excel Cell References Not Updating Mon Mar 02, 2009 4:15 pm
I found the answer after on-line.
The remedy is to go to Tools > Options > Under the Calculation TAB make sure "Automatic" is selected
Subject: Excel Cell References Not Updating 
Mon Mar 02, 2009 3:42 pm