Forum Discussion
Brendon_Kelly
Jun 14, 2024Copper Contributor
Excel Formula References Changing When I Insert a Row
Hello, I have multiple excel workbooks, where if I insert a row, it stuffs up my formula references (i.e. formulas start referencing the wrong cells) even though I haven't changed the formula. Th...
Brendon_Kelly
Jun 16, 2024Copper Contributor
This is exactly the issue I am having. And sometimes if I try to insert rows, excel simply won't insert them.
I have been using excel prolifically for the past 10 years and this is issue has only just started occurring in the past two weeks.
RPresearch
Jun 25, 2024Copper Contributor
I'm also having the exact same problem after getting a new computer and installing office. I've used excel for decades and have never had this issue. Extremely frustrating. Everything I can find online just says to use $ to lock cell references but you shouldn't have to do this to keep formula references relative when inserting rows into a worksheet. Right now inserting a row messes up every formula above it in all of my worksheets. Did anyone figure out how to fix this issue?
- SergeiBaklanJun 26, 2024MVP
Could you please give bit more details with which formulae you use. If not sample file when screenshot. Also - moving from one computer to another did you change Office or not, e.g. it was 2019 and now 365 or 2021; or that's exactly the same Office platform and version?