We recently ran into a problem up at work where people were opening a particular spreadsheet from a network fileshare, which had a lot of formulas that were tied to a few inputs. You would typically change one input cell, and a lot of the other related cells would be recalculated and updated automatically. However, a wierd issue started occuring where some users would change the input and nothing would happen. But ... when they saved the worksheet, all of the related calculated cells would be updated at that time.
I think the issue was related to one person opening the spreadsheet on a Mac that was running Office 2008, and when they saved it we noticed it changed a lot of subtle things like the colors or formatting ... but I think it may have also changed the formulas to be manually updated and only automatically updated when the file is saved, which is an Excel Option. Regardless of how this issue occurred ... here is the fix:
- Open Excel, and click on the
icon in the top left of the window, then go to Excel Options.
- Then go to the Formulas tab, and change the Calculation options to Automatic, and hit OK to apply the changes.
