"Calculating Cells: 20%", etc.

[Connie Martin]

Just wondering if there's anyway to speed up an Excel file, or if it is
strictly to do with our server and there's nothing I can do. I am using
Excel 2003 SP3. My workbook contains 16 worksheets, with links. The main
data worksheet now contains 1,394 rows. If I make one little change in one
cell, it take forever to recalculate the worksheet. Is there anyway to
speed this up? Thank you. Connie

 

[Gary''s Student]

Batch up your changes:

1. set the calculation mode to manual
2. type in your updates
3. calculate the worksheet manually with F9

 

[Connie Martin]

Thank you! This works better. It still calculates the cells slowly but at
least I can choose when it caculates, instead of it interrupting me for every
little change I would make. I was actually typing data into a much smaller
spreadsheet and pasting it in this big one because it was so slow, but I
don't have to do that any more, so you've saved me time. Thanks again!
Connie