Hi all,

I have a spreadsheet that is 50MB and is taking close to a minute to open.
The spreadsheet contains an Output table that has 120 VLookups and 12 other data worksheets each containing a variety of 350 IF, SUMIF and other formulas.

I also have a macro that I run on each data sheet that performs conditional formatting, copies unique records, copies down formulas, sorts AZ which then updates the Output table. – this also takes about a minute to complete.

Without going into the mechanics or reengineering of the sheet is there anything simple someone can recommend that I can apply to reduce the size of the spreadsheet or the time it takes to open or run the macro?

Many thanks