Adding rows in excel moves the reference from the cells

Question

Hello,

In the past few days, my co-workers and I encountered an issue when trying to add rows in our Excel files.

For some reason, When a new row is added, the cell references in the existing rows below do not update automatically.

We have tried updating Excel, repairing the Office installation, checking the reference types (relative vs. absolute), and removing the adds-in. Despite these efforts, the issue persists.

We will be waiting for your response.

Thank you!

Answer 1

Our IT department followed these instructions and reverted back to the suggested version. This did not fix the issue and the workbook still breaks when rows are added.

Answer 2

Try Rolling back Office update

ODT tool

How to revert to an earlier version of Office - Microsoft Support

Or CMD

1. Start an Office application (such as Excel), and then select File > Account. select Update Options > Disable Updates.
2. Type cmd on the start menu, right click on the Command Prompt, choose Run as Administrator
3. Copy/paste these two commands one at a time and press enter

cd %programfiles%\Common Files\Microsoft Shared\ClickToRun

officec2rclient.exe /update user updatetoversion=16.0.17531.20152

Answer 3

A coworker and I have been having this exact same issue. Really hinders the function of our workbooks. Have you been able to locate a solution to this issue?

Answer 4

We will raise it with our IT

Thank you!

Answer 5

Could you share a test file to reproduce your issue? It could be bug. Recently, some users also reported a similar situation.

For sharing a sample workbook, upload to OneDrive or any other cloud drives. Then post a link here.

Why a sample file is important for troubleshooting. How to do it. - Microsoft Community

You may also raise it to Microsoft to fix it.

Please contact your admin/IT department create a support ticket via Microsoft 365 Admin Center> Support> New service request. Support team there will have the correct channel and resources to help you investigate more and find what exactly the reason has caused this situation.

Get support - Microsoft 365 admin | Microsoft Learn

About how to find the admin in your organization, you can refer to How do I find my Office 365 admin