NWA Intactix Users Group

For users of Intactix software in the NW Arkansas region and beyond
 
HomeCalendarGalleryFAQSearchRegisterMemberlistUsergroupsLog in

Share | 
 

 Excel Cell References Not Updating

View previous topic View next topic Go down 
AuthorMessage
jmiller



Number of posts : 5
Location : Bentonville
Company : US Nutrition
Title : Category Development
Registration date : 2008-05-08

PostSubject: 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?
Back to top Go down
View user profile
jmiller



Number of posts : 5
Location : Bentonville
Company : US Nutrition
Title : Category Development
Registration date : 2008-05-08

PostSubject: 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
Back to top Go down
View user profile
 
Excel Cell References Not Updating
View previous topic View next topic Back to top 
Page 1 of 1
 Similar topics
-
» How to write in excel
» Parametrization using Excel in JUnit or TestNG
» My husband has charted my migraines on Excel
» DataDriven from Excel in C# with NUnit
» How to import the values from excel

Permissions in this forum:You cannot reply to topics in this forum
NWA Intactix Users Group :: Tips N Tricks :: MS Excel-
Jump to: