We have Excel document which is pretty basic except having few VLOOKUP formulas. Those VLOOKUP formulas get the data (mainly name, address, email, etc.) from the other workbooks within the same spreadsheet, when we enter the specific number which is on the same workbook as the data (i.e. we enter 362 and VLOOKUP populates it all for us). We do not add that many new entries to the data workbook. The other workbook calculates rent for us on the monthly and annual basis automatically. Since November, the spreadsheet grew in size 3 times the original size, but we added minimal amount of data there (it is about 2Mb now). In addition to that, Excel is freezing a lot when opening and using it spreadsheet. We checked that there are no objects or formulas or links which should not be there. We suspect that the issue may be with VLOOKUP formula, here is one of them:
=VLOOKUP(C22,'Tenants and Property Addresses'!$A$2:$E$220,3,0)
Any ideas what might be wrong with that spreadsheet?