NWA Intactix Users Group
Would you like to react to this message? Create an account in a few clicks or log in to continue.

NWA Intactix Users Group

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

 

 Excel Cell References Not Updating

Go down 
AuthorMessage
jmiller




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

Excel Cell References Not Updating Empty
PostSubject: Excel Cell References Not Updating   Excel Cell References Not Updating Icon_minitimeMon 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
jmiller




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

Excel Cell References Not Updating Empty
PostSubject: Re: Excel Cell References Not Updating   Excel Cell References Not Updating Icon_minitimeMon 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
 
Excel Cell References Not Updating
Back to top 
Page 1 of 1
 Similar topics
-
» Opening RL results in Excel; not Excel embeded in IExplore
» Excel VBA (CreateObject calls and OLE) to Intactix hierarchy
» Return a zero when reference cell is blank

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