My excel workbook is not updating automatically

[m27mitchell]

Hello. I've spent a week on a workbook I've created, and the formulas all worked yesterday, then I come in this morning in time to show my upper management the functionality (so proud of all the hard work put into it) just to have it not update. What could cause this? I have so many different formulas in different places, pulling from other sheets, etc. I click into the box with the formula and it's all still there, then when I hit enter while clicked in the cell, it updates. The deciding factor that links to certain cells is names picked from a drop down list. I will pick a name and yesterday that would cause a chain reaction throughout the workbook updating various info throughout that is attached to that name. Today, I pick a name from the drop down and it doesn't update throughout the workbook. I'm so stressed and scared that I just lost everything I've worked so hard on. Any ideas?

 

[dave3009]

Hi,

Is the calculation mode set to manual? Go to Office Button | Excel Options | Calculation and check what it is set to.

 

[steve the fish]

Is workbook calculation set to automatic? Press F9. Does that update it?

 

[m27mitchell]

It did update it when I clicked F9. I checked and it was set to manual! Oh my goodness you are both life savers. I was literally sick. So now that I've chosen the Automatic option, it will do that from now on?

 

[dave3009]

It should do but it will depend if the there is something else inadvertently turning the calculation to manual, do you have any VBA code in this or other workbooks? If you do and you want to ensure calculation is set to auto on this one then use the workbook activate event to set it to automatic

 

[m27mitchell]

No VBA in the workbook. Yay! Just made my life so much better. Thank you all so much for the help. Have a wonderful weekend!