Joshua McNichols
New Member
- Joined
- Mar 22, 2013
- Messages
- 30
All of a sudden, deleting an entire row has become a calculation too complicated for Excel to calculate. It seems the RANGE of even a single row exceeds 33,000 cells - and therefore I get a warning that this could take a long time. Ignoring this warning does no good - Excel then tells me it couldn't do it. "Excel cannot complete this task with available resources. Choose less data and or close other applications."
In another seemingly related problem, I used a macro to automatically extend my formulas down 15,000 rows. I had hoped that I'd never have to drag down formulas again. But instead, this action created a much larger range of cells Excel now seems to consider "active." That means I can no longer use my scroll wheel, for example, to navigate my 300-row spreadsheet, because the scroll wheel seems to move the cursor up and down as a percentage of the total document length - a length now 15,000 rows long - and whatever percentage of that length each click of the scroll wheel was supposed to cover is now too miniscule to notice.
How do I make this spreadsheet "small" again?
And am I right in believing I should just convert the thing to a table and somehow that would simplify my life?
Thank you
In another seemingly related problem, I used a macro to automatically extend my formulas down 15,000 rows. I had hoped that I'd never have to drag down formulas again. But instead, this action created a much larger range of cells Excel now seems to consider "active." That means I can no longer use my scroll wheel, for example, to navigate my 300-row spreadsheet, because the scroll wheel seems to move the cursor up and down as a percentage of the total document length - a length now 15,000 rows long - and whatever percentage of that length each click of the scroll wheel was supposed to cover is now too miniscule to notice.
How do I make this spreadsheet "small" again?
And am I right in believing I should just convert the thing to a table and somehow that would simplify my life?
Thank you
