"Calculating Cells: 20%", etc.
Batch up your changes:
1. set the calculation mode to manual
2. type in your updates
3. calculate the worksheet manually with F9
--
Gary''s Student - gsnu200903
"Connie Martin" wrote:
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
|