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...
The #VALUE error is a bit tricky because some functions automatically ignore invalid data. For example, the SUM function just ignores text values, but regular addition or subtraction with the plus (+) or minus (-) operator will return a #VALUE! error if any values are text.
You can read this MVP https://excelchamps.com/fix-corrupt-excel-file/.