For anyone who wasn't aware, my IT guys just told me that in December 2019 the maximum accessible memory for 32 bit excel running on 64 bit windows was increased from 2GB to 4GB. My ongoing battle to get 64 bit Excel playing nicely can take a break until next year when my model has doubled in size again:-)
Source: https://docs.microsoft.com/en-us/office/troubleshoot/excel/laa-capabilit...