Here’s something to try if you have a spreadsheet that seems to occupy far too much disk space given the content it contains.<\/p>\n
One sheet at a time, try moving a sheet to a blank workbook and then moving it back to the original workbook until you have done it for all workbooks. I can only guess this copies over only useful information and leaves the invisible cruft behind but have no hard evidence to prove how this process worked for me.<\/p>\n
As always, before you muck around with important data make sure you create a backup copy in case something goes wrong<\/strong><\/span> but otherwise you can achieve this by doing the following:<\/p>\n I managed to get a spreadsheet that had ballooned out to 27MB down to 700KB and it was as good as new using this method.<\/p>\n","protected":false},"excerpt":{"rendered":" Here’s something to try if you have a spreadsheet that seems to occupy far too much disk space given the content it contains. One sheet at a time, try moving a sheet to a blank workbook and then moving it back to the original workbook until you have done it for all workbooks. I can … <\/p>\n\n