Hi,
I have an .xlsx file of 30mb that has lots of sheets with tables that look up data from other sheets in the workbook. Usually when I hard-paste all of the formulae in the lookup tables and delete the supporting data sheets, and then save the amended file, it drops in size to about 8mb. However, this time the file size has only dropped by around 1mb.
Can anyone please suggest why the file size is still so bloated?
Thanks
Bookmarks