Feb 05 2021 04:48 AM
I have two similar (they have the same amount of information on each one) spreadsheets that I normally use. However, one for some reason is 51.5 KB and the other 131MB. How can I convert the large one to 51.5 KB? The large one takes a long time when trying to save. Thank you
Feb 05 2021 07:14 AM
Make sure that the columns and rows beyond the visible used range are really empty.
Then try the following:
Does that make a difference?
Feb 05 2021 08:09 AM
As variant, if you have Inquire in your version of Excel you may Clean Excess Cell Formatting with it.