Dear Forum,

I have made a WorkBook which has a lot of Formulas such as SUMPRODUCT & INDIRECT and there are several such sheets..

Now this File has become extremely slow and for every change it goes into Calculation Mode, now how do I change the approach and get the desired result and still make it faster.

If I make these Formulas into VBA will that make the File faster?

I can also adapt to an approach where the Formulas are still written in Formulas but in the VBA Mode and then convert it to Values.

Need advise on an urgent basis..

Warm Regards
e4excel