Excel

Hi Gal,

Thank you for the forum question.

Based on what I saw in your file the combination of SUMPRODUCT and nested IFs is one of reasons for the speed is slow. Can you not use SUMIFS/COUNTIFS to do the same?

As I mentioned conditional formatting is also a reason.

Replace VLOOKUP with XLOOKUP or INDEX/MATCH.

Your file isn't huge, you are not having unused ranges, so I am pretty sure that your problem must be found in the Excel functions you are using.

You are right about that it is slowing down the file to have the data across many sheets.

Below you can find two links to websites with a number of useful tips to speed up Excel

https://trumpexcel.com/suffering-from-slow-excel-spreadsheets/

https://chandoo.org/wp/75-excel-speeding-up-tips/ #formulas


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector