Clearing cache in Excel 365 files to reduce file size.

Question

I have worked for many years with excel, creating a great deal of tools but I am always frustrated, when making changes to the data or formulas, that the size of the file increases exponentially, and I realized that it is probably the cache that supports the "undo" options, but I am wondering if that cache gets dumped or is there a way to clear it, to reduce the size of the file?

Answer 1

@Malcolm and Maribel Boswell ,
Generally, some caches related to Excel files are saved independently.

As far as know, if you want to reduce the Excel file size, we may do it via remove conditional formatting, crop each worksheet to its used range, clear data formatting, do not save the pivot table source data cache with the file and etc.

The detailed information, please refer to "Reduce the file size of your Excel spreadsheets".
Also you may check whether the article "7 easy ways to reduce your Excel file size right now" is helpful.
(Please Note: Since the web site is not hosted by Microsoft, the link may change without notice. Microsoft does not guarantee the accuracy of this information.)

Any issues, please let me know.

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.