I have a Modano model that has grown a rather large memory footprint. Now, I have upraded my computer to 64bit and upgraded Office to 2016 so I am fine, but this is a workbook I share with my coworkers and I am getting increasing tired off their moans and groans every time their Excel sessions runs out of memory when they save and I am somehow the one to blame(!). Large company with outsourced Helpdesk means getting them onto 2016 Office is going to be a painfully slow process so in the meantime I thought I would try to optimise the model as much as I could.
Does anyone have any experience with optimising 'heavy' workbooks, and if so what should I look to change to get maximum effect? Are there any specific formulas I should get rid off (I'm thinking Sumif/sumproduct but from a quick google I also noticed that Index,Match and offsets are other memory hungry formulas)? I have some conditional formatting, should I get rid of this?
Any help will be much appreciated!