That is correct, no circular references and circular references are not allowed.
2016 excel formula not updating
Then why did my RTD server push data on a timer callback before but now nothing updates?
And by the way I never even hinted at wanting to update upon changing a formatting.
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site.
If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Three attempts later and it was still adamant it wanted to be "Manual" and nothing else.
Copy the contents of the spreadsheet to a new one, and deleted the old one (it wasn't a particularly important spreadsheet, thankfully), and everything was fine.I am using Excel 2016 and having trouble with formula references.Formula cells remain the same after their positions on the sheet change.Other references are updating fine though, it is just this one [email protected] Williams Both Ctrl-Alt-F9 and Ctrl-Alt-Shift-F9 updated the cells and made it so they are updating correctly. I searched the Excel Help and found this in the help article titled I had a similar issue with a VLOOKUP.After saving and reopening, the spreadsheet is still working correctly. The field I was using to VLOOKUP was formatted as a custom field. Clearing this error (selecting all fields with the error, beginning with the first one with the error and clicking change to Number even though I didn't really want it to be! the ctrl alt f9 , is the temporary solution , going to options-formula-auto calculate is the right way, that option turned manual, because some shortcut key on being pressed by mistake turns automatic to manual Thank you for your interest in this question.I need updating on changing valuesthe post says: "..when formatting is changed to show seconds...".