jmiller
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 |
|
