当前位置: 动力学知识库 > 问答 > 编程问答 >

Excel formulas not calculating after restart

问题描述:

For some weird reason excel stopped calculating formulas for me. I switched it to automatic in options but whenever I restart excel it is switched to manual... I can't get it to remember the settings. What should I do?

网友答案:

Excel sets the calculation mode from the first workbook opened in a session, and does not change when you open another workbook that was saved using a different calculation mode.
You can change the calculation mode subsequently within the excel session using the Calculation Options or by VBA. So -

either the workbook you are opening was last saved in Manual calculation mode

or you have a workbook saved in manual calculation mode in your XLStart folder

or you have a personal.xls workbook that is set to Manual

or you have some VBA somewhere that resets calculation to manual

分享给朋友:
您可能感兴趣的文章:
随机阅读: