Quote Originally Posted by Marcol View Post
After a quick look at your workbook I would suggest it isn't the macro that's dragging the workbook down, it's the formulae you are using.

You have an excessive amount of volatile functions, mainly INDIRECT().

Your workbook is over complicated many sheets and tables are duplications of data already in the workbook, this combined with the volatile functions used to create them is a recipe for failure.

This might seem hard on you, but your workbook needs serious reorganisation.
There is no point in trying to find a solution to a situation that should not exist in the first place.
I just made an experiment. Replaced all the Indirect functions from MLOOKUPs and from all the sheets (just pasted values) and it has led to NO improvement in time at all. Not even a second faster. So it is clearly not the case.