Too many Cells referenced when I try to move rows into another sheet

George Lie

Hi guys, I wanted to move rows into another sheet (around 100 rows). it is said that there are too many cells referenced by formulas in this sheet, which is odd, because the limit for cross-reference is upped to 250,000 last I checked. The total of Cross referenced column is 4, I currently have 912 rows in this sheet, and 4000ish in the destination sheet (no cross-references there).

here is my reference manager (8 range references)

George Lie

Ps: this never happened before, I usually use automation to move the rows, and it worked quite well before

Andrée Starå

Hi @George Lie

I hope you're well and safe!

I'm looking at the sheets, but I wanted to clarify one thing. The limit is 100,000 and not 250,000.

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!