Forum Discussion
Maria_Malygina
Apr 13, 2022Copper Contributor
EXCEl changes formulas automatically after update
Good afternoon, I ran into a problem - the link is to a Merged cell (G235) and after updating Excel, the link goes to 2 merged cells (G235:H235), which automatically gives an error and incorrect dat...
Riny_van_Eekelen
Apr 13, 2022Platinum Contributor
Maria_Malygina What is the error you get?
As a general comment, it's better to avoid merged cells to begin with. They often cause trouble, though, I have not heard about the problem you described, where a formula is changed due to an update.
Maria_Malygina
Apr 13, 2022Copper Contributor
Riny, it's - #VALUE, in some cases it's imposible, thank you for advice. We just faced it, didn't have it before, even we use this file for a while.