Very long workbook computation time (F9 manual compute)

[Floss]

I have a complicated worksheet that takes too long to recompute. My
worksheets are very well organized as far as dedicated source data and
dependent data worksheets.
Is there a way to set priority on what worksheets are computed first,
second, third and ect. as means increasing computation efficiency?

 

[Niek Otten]

To learn all about calculations speed (and more) of Excel, visit Charles William's site:

www.decisionmodels.com

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have a complicated worksheet that takes too long to recompute. My
| worksheets are very well organized as far as dedicated source data and
| dependent data worksheets.
| Is there a way to set priority on what worksheets are computed first,
| second, third and ect. as means increasing computation efficiency?
|