Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation performance
Hi all,
I've a workbook with hard coded formulas without VBA code. Which includes Groups & outlines, name ranges, conditional formats and functions like if, sumif, indirect, arrays, etc., for each change in a single cell taking too much of time for recalculating the workbook. And also the same time consuming for recalculation during groups expanding and collapse. Any one can help me how to recalculate only dependent cells and conditional formats for the same. And how to stop recalculation during expanding and collapse groups. Advanced Thanks, Vinod. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Performance on calculation - 2003 vs 2007 | Excel Discussion (Misc queries) | |||
Performance IF(IF or IF(AND | Excel Worksheet Functions | |||
Excel performance calculation | Excel Worksheet Functions | |||
annualized return calculation for the purpose of portfolio performance evaluation | Excel Worksheet Functions | |||
Performance Grouping | Excel Discussion (Misc queries) |