View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Bob is offline
external usenet poster
 
Posts: 972
Default Increase Speed of Calculations

My worksheet has about 100,000 calculations and is very slow in calculating
them. It is taking me about 5-8 minutes to calculate the entire worksheet on
a machine that has 4GB of RAM. The worksheet size is 21 columns by over 6,000
rows. Do anyone know of a way to increase the calculation speed without
breaking the data ino several different workbooks?