Forum Discussion
Excel formula translation corrupts sheet
Dear experts, receiving an Excel from a foreign country leads to an unintended translation of the formula in a series of cells, which leads to lots of cells giving #VALUE fault messages. What could s...
#VALUE is Excel's way of saying, "There's something wrong with the way your formula is typed. Or, there's something wrong with the cells you are referencing." The error is very general, and it can be hard to find the exact cause of it.
Read this https://support.microsoft.com/en-us/office/how-to-correct-a-value-error-15e1b616-fbf2-4147-9c0b-0a11a20e409e#:~:text=%23VALUE%20is%20Excel's%20way%20of,the%20exact%20cause%20of%20it.