Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Why not automatically updating calculations?
For some reason formulas that I have been using often that would automatically recalculate after I had made modifications for the cells in their range are no longer doing this automatically. I have to double-click the cell so that the formula is visable and then enter to force the formula into updating. I know this shouldn't be but not sure why or what to do to fix. Please help the newb.
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why not automatically updating calculations?
Hi walkingmac. Check Tools - Options - Calculation tab and make sure that
Automatic is checked. -- Sincerely, Michael Colvin "walkingmac" wrote: For some reason formulas that I have been using often that would automatically recalculate after I had made modifications for the cells in their range are no longer doing this automatically. I have to double-click the cell so that the formula is visable and then enter to force the formula into updating. I know this shouldn't be but not sure why or what to do to fix. Please help the newb. -- walkingmac |
#3
|
|||
|
|||
ahh... yes, that did it. Thank you. Not sure how that could have been disabled on throughout the machines, but yes, thanx.
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why not automatically updating calculations?
Your welcome. Thanks for the feedback
-- Sincerely, Michael Colvin "walkingmac" wrote: ahh... yes, that did it. Thank you. Not sure how that could have been disabled on throughout the machines, but yes, thanx. -- walkingmac |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why not automatically updating calculations?
Mac
ToolsOptionsCalculation can be Auto or Manual. Excel takes the Calculation mode each session from the settings on the first workbook opened in that session. i.e. If you saved Book1 with calc mode in manual and opened it first, calc mode would be in Manual. If you saved Book2 with calc mode in auto and opened it after Book1, Book2 would be in manual mode(Excel ignores the auto calc mode in this case). If you close Book1 before opening Book2, Book2 will be in auto calc mode. Confusing enough? <g Gord Dibben MS Excel MVP On Mon, 6 Mar 2006 12:50:04 +0000, walkingmac wrote: ahh... yes, that did it. Thank you. Not sure how that could have been disabled on throughout the machines, but yes, thanx. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why not automatically updating calculations?
Could get turned by a macro or by an addin.
Turning off calculation will make macro run faster but forgetting to turn it back on particularly when the macro abnormally terminates will leave calculation at manual. If the problem recurs you can have your Excel tell you when you start up Excel that calculation is not set at automatic and then perhaps you can remember what you did in the previous session. http://www.mvps.org/dmcritchie/excel...esp.htm#addins --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "walkingmac" wrote in message ... ahh... yes, that did it. Thank you. Not sure how that could have been disabled on throughout the machines, but yes, thanx. -- walkingmac |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel formulas are not automatically updating | Excel Discussion (Misc queries) | |||
Updating a chart automatically | Charts and Charting in Excel | |||
Automatically updating Graphs | Excel Worksheet Functions | |||
updating charts automatically | Charts and Charting in Excel | |||
Updating calculations automatically when i enter in new data | Excel Discussion (Misc queries) |