问题描述
这很奇怪.
我有一个包含公式的excel文件，该文件可以在不同国家/地区的用户之间来回发送(不同语言设置的可能性更大).要获取要计算的公式，请点击启用编辑，以计算工作簿中的所有公式.
I have an excel file with formulas which is emailed back and forth between users in different countries (different language settings more than likely).To get the formulas to calculate, you hit enable editing which calculates all the formulas in the workbook.
在Windows 10上，我收到一个文件，当我单击启用编辑时，除非手动手动进入每个文件并单击return，否则不会计算公式.如果我从Windows 8打开相同的文件，它将进行计算.
On windows 10, I receive a file and when I hit enable editing, the formulas do not calculate unless I manually go into each one and hit return. If I open the same file from windows 8, it calculates.
公式已正确设置为自定义"，并且自动公式计算已启用，如果您单击立即计算"，则工作表不进行计算.没有循环引用.
The formulas are correctly in as "custom" and automatic formula calculation is on, the sheet does not calculate if you hit calculate now. There are no circular references.
我尝试的另一种解决方法是将所有=符号替换为=.
Another fix I tried was replacing all the = signs with =.
有人遇到这个问题吗?我没有应用到Office的更新的详细信息，但我假设发送方和接收方都是最新的.
Anyone come across this issue? I do not have details of applied updates to office but I am assuming the sender and the receiver are up to date.
推荐答案
我不确定这种情况如何发生或我描述的方法为何起作用，但它对我有效.
I am not sure how that happens or why the method I am describing works, but it works for me.
使用文本到列中，选择固定宽度，但实际上不将任何内容分隔到列中并单击完成.您应该获得该公式的所有结果.但是，如果您的公式位于许多不同的列中，那将是一个真正的痛苦.
Using text to columns, select fixed width but don't actually separate anything to columns and hit finish. You should get all the results of the formula. However it is a real pain if your formulas are in many different columns.
这篇关于Excel公式未更新的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！