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.