Deleting Column Messed Up References in Formulas

I was working in Worksheet A, which had a linked row to Worksheet B. I deleted Worksheet B. Then I deleted the related row column from Worksheet A. This column was to the right of everything I was working on (not sure if that matters). After I deleted the column, I got a message saying the worksheet was no longer synced. Then it reloaded the worksheet, and all of my references within the worksheet had shifted to the left by one column. Took a long time to fix.

We are internally tracking this as #001625

Issue 001625 was resolved in a recent update. Marking this thread as solved.

2 Likes