Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Quantifying Calculation Steps in a Workbook
I am using various methods to reduce the time needed to calculate a workbok.
Is there a way to quantify exactly how many calculation steps must be performed when the file fully calculates. I'm trying to get a reference point and track how the changes are affecting calculation time in a quantifiable way. It's tough to get a good read by pressing F9 and trying to "ballpark" whether it was faster or slower than the last time. Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Quantifying Calculation Steps in a Workbook
This might be of interest to you:
http://www.decisionmodels.com/fxluserf.htm -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Adam Hollerbach" <Adam wrote in message ... I am using various methods to reduce the time needed to calculate a workbok. Is there a way to quantify exactly how many calculation steps must be performed when the file fully calculates. I'm trying to get a reference point and track how the changes are affecting calculation time in a quantifiable way. It's tough to get a good read by pressing F9 and trying to "ballpark" whether it was faster or slower than the last time. Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Quantifying Calculation Steps in a Workbook
Thank you for responding so quickly. Is there a simpler way without having
to purchase and run software? All I want to know is whether my adjustments are helping or hurting my calculation time. "Ragdyer" wrote: This might be of interest to you: http://www.decisionmodels.com/fxluserf.htm -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Adam Hollerbach" <Adam wrote in message ... I am using various methods to reduce the time needed to calculate a workbok. Is there a way to quantify exactly how many calculation steps must be performed when the file fully calculates. I'm trying to get a reference point and track how the changes are affecting calculation time in a quantifiable way. It's tough to get a good read by pressing F9 and trying to "ballpark" whether it was faster or slower than the last time. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Open CSV causes calculation in manual calc mode | Excel Discussion (Misc queries) | |||
Repost:Automatically inserting a row in external workbook | Excel Discussion (Misc queries) | |||
Protect Workbook vs Worksheet?? | Excel Worksheet Functions | |||
How to hyperlink from a workbook to sheets in another workbook? | Excel Worksheet Functions |