Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Questions about Strange ReCalc Behavior
I'm currently struggling with an MOAS (that's "Mother of All Spreadsheets")
that someone else at work has given to me. It's 28 MB and takes several seconds to re-calculate. I'm in the process of trying to diagnose ways in which I can make it more efficient (Ultimately I'll need to run it as part of a Monte Carlo simulation--25,000 recalcs, so every second is important). I've run into a couple of peculiar Excel behaviors. Can anyone explain these? 1) I can do an F9 recalc on any sheet. However, there are a couple of sheets (out of maybe 15) which, if I try to do a "Sheet Recalc" via Tools...Options Calculation Tab, causes Excel to calculate indefinitely. (Or so it seems...the percentage number on the status bar doesn't change, but the Excel process shows 99% CPU use in Task Manager.) I discovered this when I was trying to do individual sheet recalcs in a VBA macro to diagnose calculation bottlenecks. Anybody know why this happens or what I can do to fix it? 2) When I am connected directly to my office network, the recalc time for my workbook is around 3 seconds. If I run it at home using the same machine, while disconnected from the office network, the recalc time is 11 seconds. The workbook has no external references whatsoever. Does anyone know why this disparity occurs? 3) And finally, can anyone point me to resources available to diagnose and speed up Excel calculations? I've seen the Knowledgebase and MSDN articles. Are there diagnostic software tools or other sources of information that would help me make this thing more efficient? Sorry for the long post. Thanks for the help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Questions about Strange ReCalc Behavior
For speed issues, visit
www.decisionmodels.com -- Kind regards, Niek Otten "LawrenceHG" wrote in message ... I'm currently struggling with an MOAS (that's "Mother of All Spreadsheets") that someone else at work has given to me. It's 28 MB and takes several seconds to re-calculate. I'm in the process of trying to diagnose ways in which I can make it more efficient (Ultimately I'll need to run it as part of a Monte Carlo simulation--25,000 recalcs, so every second is important). I've run into a couple of peculiar Excel behaviors. Can anyone explain these? 1) I can do an F9 recalc on any sheet. However, there are a couple of sheets (out of maybe 15) which, if I try to do a "Sheet Recalc" via Tools...Options Calculation Tab, causes Excel to calculate indefinitely. (Or so it seems...the percentage number on the status bar doesn't change, but the Excel process shows 99% CPU use in Task Manager.) I discovered this when I was trying to do individual sheet recalcs in a VBA macro to diagnose calculation bottlenecks. Anybody know why this happens or what I can do to fix it? 2) When I am connected directly to my office network, the recalc time for my workbook is around 3 seconds. If I run it at home using the same machine, while disconnected from the office network, the recalc time is 11 seconds. The workbook has no external references whatsoever. Does anyone know why this disparity occurs? 3) And finally, can anyone point me to resources available to diagnose and speed up Excel calculations? I've seen the Knowledgebase and MSDN articles. Are there diagnostic software tools or other sources of information that would help me make this thing more efficient? Sorry for the long post. Thanks for the help. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Questions about Strange ReCalc Behavior
Thank you, Niek. It looks like there are a lot of information there on
Excel's calculation engine. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Strange behavior | Setting up and Configuration of Excel | |||
Strange behavior. | Excel Discussion (Misc queries) | |||
Strange Personal Macro Workbook Behavior | Excel Discussion (Misc queries) | |||
Strange behavior w/ Text, Button, & Check Boxes | Excel Discussion (Misc queries) | |||
Baffling Sum/Average Behavior | Excel Discussion (Misc queries) |