Too many bytes on spreadsheet

Copper Contributor

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

2 Replies

@pcubeta 

Make sure that the columns and rows beyond the visible used range are really empty.

Then try the following:

  • Press Alt+F11 to activate the Visual Basic Editor.
  • Press Ctrl+G to activate the Immediate window.
  • Type the word ActiveSheet.UsedRange and press Enter.
  • Switch back to Excel and save the workbook.

Does that make a difference?

@pcubeta 

As variant, if you have Inquire in your version of Excel you may Clean Excess Cell Formatting with it.