View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default "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