Forum Discussion

Maria_Malygina's avatar
Maria_Malygina
Copper Contributor
Apr 13, 2022

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...
excel
Formulas and Functions
office 365
Maria_Malygina's avatar
Maria_Malygina
Copper Contributor
Apr 13, 2022
no, it's within excel book
jitinm's avatar
jitinm
Iron Contributor
Apr 13, 2022
Usually it does not happen. Can you share a screen shot?
  • Maria_Malygina's avatar
    Maria_Malygina
    Copper Contributor
    Apr 13, 2022
    that's why I'm asking) No I can't
    • jitinm's avatar
      jitinm
      Iron Contributor
      Apr 13, 2022
      Maybe the cell/formula you have referenced is relative and not fixed
      • Maria_Malygina's avatar
        Maria_Malygina
        Copper Contributor
        Apr 13, 2022
        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.

Resources