Forum Discussion
Excel Formula References Changing When I Insert a Row
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.
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?
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?
