ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Very long workbook computation time (F9 manual compute) (https://www.excelbanter.com/excel-discussion-misc-queries/176716-very-long-workbook-computation-time-f9-manual-compute.html)

floss

Very long workbook computation time (F9 manual compute)
 
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

Very long workbook computation time (F9 manual compute)
 
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

"Floss" wrote in message ...
|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?
|




All times are GMT +1. The time now is 10:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com