| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Controling recalculation - or how to solve my speed problem?
Are the named ranges dynamically sized or are they a
fixed size with unused rows in them? They are fixed (not going through all 65535 of them ;-) Charles Williams says it all about Excel calculation... http://www.decisionmodels.com/optspeedb.htm Interesting. I was now able to turn the autmatic calculation off, which partially solves my problem - but doesn't answer my question what takes so long. Probably worth taking a look at C.Ws tool... Peter |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Recalculation Problem After Save As. | Excel Discussion (Misc queries) | |||
| Improving Recalculation Speed for Complex Links | Excel Discussion (Misc queries) | |||
| Problem when multipple users access shared xl-file at the same time, macrocode for solve this problem? | Excel Programming | |||
| Recalculation Speed After Editing Macro Code | Excel Programming | |||
| Formula recalculation speed | Excel Programming | |||
Hybrid Mode
