I have an Excel 2007 spreadsheet which extracts large quantities of data from a spreadsheet. Even after I delete the data, the spreadsheet is still very large. I think it's because copies of the data are still stored in the cache.
Is there a way for me to clear the cache (either in Excel itself or by using a VBA macro) without actually deleting the destination cells? I wouldn't want to delete them since doing so would destroy the formatting I need.