Hi

I have a spreadsheet that has lots of formulas and linked files. The recalculation is very time consuming! I have written a VBA routine to perform some some tasks in it. One of the 1st things I do in the code is to set the recalculation method to manual and turn off the recalculate before save option, this speeds up the operation. The problem I have is that at the end of the routine I need to return these 2 settings to their original states and in doing this the spreadsheet automatically recalulates itself twice (once after the reverting calc method to Automatic and once after turning the recalculate after save option back to true).

Does anyone know if there is a way to prevent this automatic recalculation of the sheet occurring after turning back on these settings? The operations I am carrying out in the code do not alter the value of cells in anyway so there is no need for it to happen and it vastly increases the time taken to run the thing.

Many thanks

Ben