![Excel for mac updated and now it will not save](https://kumkoniak.com/46.jpg)
On the other hand, if this is a macro workbook, certain codes will also have the same effect. If there is certain functions and the calculation options is “Automatic”, whenever you open the file, those functions will recalculate automatically and produce new results. In this image, you can see that the calculation options is “Automatic”. And then click the button “Calculations Options”.Click the tab “Formulas” in the ribbon.Other functions also include NOW, TODAY and others.Īnd now check the calculation options of the current workbook. Sometimes you will use it in your worksheet to get some random numbers. Some formulas don’t need to refer to another cell. In an Excel with plenty of data, it will certainly contain formulas. To figure out the reason, you may continue referring to the rest of the article. But you will see that this button is also invalid. The easiest way is to check whether the “Undo” button is available. You can click the button “Cancel” and find in the file. However, when you open another workbook and check certain values instead of changing it, you will still see the information.
![excel for mac updated and now it will not save excel for mac updated and now it will not save](https://i.stack.imgur.com/L8m5v.png)
It is indeed a very good feature that can avoid data loss to certain degree. If you make some modifications to an Excel file and then close it without saving, it will ask you whether you want to save the changes. But actually you make no change to the file. Sometimes you will see the information that asks you whether you want to save the changes or not.
![Excel for mac updated and now it will not save](https://kumkoniak.com/46.jpg)