View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Inserting row takes 1 - 3 minutes.

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
--
Max
Singapore
xde
---
"CarylK" wrote:
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