I have an excel which is full of formulae,
i noticed when i perform operations in excel scope like copy paste range and delete range its faster when the “Formula>Calculation Options>Manual” is selected.
I tried using send hot key, ALT + MXM, however its not reliable.
Any vba or faster way to switch between the modes?
was thinking to update the mode to manual first, update the processing and then update it back to automatic mode.
Any feedback or suggestions will be greatly appreciated.