If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Links / Formulas not updating
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. I've already checked Tools - Options - Calculation set to Automatic. Even tried hitting F9 several times and clicking the Calc sheet button. Problem is not affecting all open spreadsheets and I can't find any common link between the ones that are having the this problem. Thanks for your help. |
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|