Numbers Not Shifting After Inserting Rows

Why OfficeConnect elements don’t move when you insert Excel rows, and how to fix it.

Symptom: You insert rows into your Excel worksheet, but OfficeConnect data in rows below the insertion point doesn’t shift down — the elements stay in their original positions.

Why this happens

OfficeConnect element metadata is attached to specific cells. When you use standard Excel Insert Rows, Excel moves the cell values but the OfficeConnect element assignments don’t follow — they remain anchored to the original row numbers.

Fix: Use OfficeConnect’s Insert/Delete functions

Instead of Excel’s native Insert Rows/Delete Rows, always use OfficeConnect’s equivalent:

1
Select the row where you want to insert Click the row number to select the entire row.
2
Right-click and use OfficeConnect → Insert Row From the right-click context menu, select OfficeConnect → Insert Row (not Excel’s standard Insert).

This inserts a row and correctly shifts all OfficeConnect element assignments.

If you already inserted rows with Excel’s native function

  1. Undo the insert with Ctrl+Z (undo until you’re back to the pre-insert state)
  2. Reinsert using OfficeConnect’s Insert Row function

If undo isn’t available, you’ll need to re-apply elements to the affected rows manually.