Calculation Time

[Gijs Breedveld]

How can I get the time needed to calculate a sheet?
The sheet contains +400000 sumproducts and I want to find the fastes
computer in my house.

Best regards,

Gijs

 

[Niek Otten]

Hi Gijs,

Although the page title may seem off topic, look here:

http://msdn2.microsoft.com/en-us/library/aa730921.aspx

This section:

Finding and Prioritizing Calculation Bottleneck


Tells you how to time parts of your workbook

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| How can I get the time needed to calculate a sheet?
| The sheet contains +400000 sumproducts and I want to find the fastes
| computer in my house.
|
| Best regards,
|
| Gijs