MrExcel.com - Your One Stop for Excel Tips & Solutions

calculation problem

Posted by DumbBill on August 29, 2001 8:06 AM

Is there a way to calculate ONLY a selected range of cells in a worksheet? I have a large multi-sheet project which takes forever to calulate even when I turn off Automatic Calculation and do it one worksheet at a time using Manual calulation.

Posted by Mark W. on August 29, 2001 8:10 AM

For some ideas see...

http://support.microsoft.com/support/kb/articles/Q72/6/22.ASP?LN=EN-US&SD=gn&FR=0&qry=slow%20calculation&rnk=2&src=DHCS_MSPSS_gn_SRCH&SPR=XLW97