Inserting row takes 1 - 3 minutes.

C

CarylK

I'm working with an Excel 2003 workbook with six worksheets (that I've opened
in Excel 2007), one per year. There are only 14 columns with a very simple
SUM formula in column 14. This is a spreadsheet that keeps track of auction
sales by week with a grand total at the bottom of each yearly worksheet.
Pretty simple.
Since I've opened this workbook in Excel 2007, it is taking from 1 to 3
minutes to insert a blank row in the middle of other blank rows. This would
be instantaneous with the same workbook in Excel 2003. I'm not a programmer,
just a user and this is very aggravating.
Any ideas?
Thanks Caryl
 
M

Max

Try setting the calc mode to manual. Press F9 to recalc ONLY when needed.
That should help speed things up, in any version. Any good? hit the YES below
 

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

Save workbook every 5 minutes in Excel 2007 6
Excel 2003 Formula Error 2
Data in cell disappears, reappears by scrolling mouse over cell 3
Formula Audit mode active in one column only; cannot kill. 2
Excel crashes when inserting a row or column 3
Change scroll rows from 1 to 3 with mouse wheel 1
What is blue triangle? 2
Excel 2007 crashes on copying worksheet to new workbook 0

Top