Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
When hiding a row, how to avoid useless and long calculations ?
There is no way of avoiding the recalculations, except by changing to Manual
rather than automatic calculation mode. Look at http://www.DecisionModels.com/calcsecretsj.htm for some ideas on speeding up UDFs. Charles ______________________ Decision Models FastExcel 2.3 now available Name Manager 4.0 now available www.DecisionModels.com "MJ" wrote in message ... My user defined function often take several second to complete. When hiding some rows or column or when hiding in a list, Excel triggeres a recalculation. This is bad luck for me. Would you know if there is way to avoid that? Thanks, Michel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Interrupting long calculations in Excel? Hi all, I am having a verylong calculation in Excel using VBA. Of course I know I can hit ESC orCTRL+BREAK to interrupt the VBA program. But I found due to too long runningprocess, the Excel window stop to | Excel Discussion (Misc queries) | |||
Remove useless information | Excel Worksheet Functions | |||
Calculations too long | Excel Worksheet Functions | |||
useless file | Excel Programming | |||
Hiding calculations | Excel Programming |