EXCEl changes formulas automatically after update

[Maria_Malygina]

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 data in the calculations. How can this be fixed? My Excel Version 2201 Build 16.0.14827.20186 64-bit

[#2]

Is it linked to external site?

[#3]

no, it's within excel book

[#4]

Usually it does not happen. Can you share a screen shot?

[#5]

that's why I'm asking) No I can't

[#6]

Maybe the cell/formula you have referenced is relative and not fixed

[#7]

Many thanks for your response! We use file for internal calculations, and this error started to appear after Excel upgrade to new version. it automatically update formulas.

[#8]

@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.

[#9]

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.