Deleting rows with formulas is very slow

G

gramos14

I have excel 2003 and everytime I delete rows in a worksheet where there are
formulas on the worksheet, it takes a long time for the rows to delete. I
normally turn the calculation setting to Manual before deleting, but
sometimes forget. When I used to have excel 97 I never experienced this
problem.

Any thoughts?
 
M

Mike H

Any thoughts?

Deleting a row will force recalculation. Perhaps in your E97 worksheets you
had less formula.

Mike
 
G

gramos14

Actually, when this first starting happening in E03 I still had E97 on
another machine, so I tried the same file on both machines and E97 was much
faster. As we speak I am deleting rows in a E03 worksheet with formulas and
I'm 45 minutes in and its still not done. Granted its several thousand rows
I'm deleting.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Way to keep formulas unchanged when deleting rows? 9
Deleting blank rows with formulas in them 7
Easiest Way to Delete Rows 4
Inserting rows slow on large report 6
Extremely slow response times in Excel 2007 4
Why Del is Slow 2
Excel 2007 - Deleting Filtered Rows 3
Cannot delete extra rows 5

Top