Links / Formulas not updating
Tim H wrote:
For some reason, on only a few random spreadsheets that I'm working in,
formulas and links are not updating unless I goto the cell and hit a hard
return.
Which version of Excel? (It always helps if you tell us)
For links, check the setting in Edit Links Startup Prompt
Try Ctrl+Alt+F9 (forces a complete recalc).
Try Edit Replace = [with] = Replace All
(rebuilds the calculation tree)
Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup
|