XlcalculationManual

Hello,

I have used xlcalculationmanual in my macro to speed up the running time, however it when the macro saves the work book it does not save it just closes as if saveas was false.

Also using xlcalaulationmanual does this stop links to external workbooks in the workbook being updated?

Thanks in advance

Setting xlCalculaionManual to true is global, affecting all workbooks, and that setting is saved in any workbook open at the time the flag is set. As a matter of course you should set it to true at the end of execution of any code where you manipulate it it.

I did of course mean false