Decrease the file size of your Excel spreadsheets

Save your spreadsheet in binary (. xslb) format You can minimize your file size by saving your spreadsheet as a binary workbook(. xslb) rather of the default format(. xslx). The default format is XML based, which is essential if you’re using your information with third-party programs since XML is an open requirement.

1. Nevertheless, for most functions, the binary format is sufficient and

2. conserves to a smaller file. Go to File > Alternatives > Conserve. Under Save workbooks, in the Save files in this format list, choose

   

Excel Binary Workbook. This alternative sets binary format as the default. If you want to keep the default to Excel Workbook (. xlsx )but save the current file as binary,

choose the option in the Save As dialog. Keep in mind: If the file lies in a SharePoint library, you might not see the Save As alternative. If this is the case, you can conserve a copy to your local drive, save that copy as a binary, and then change the initial file with the new binary.

1. Go to File > Save As, and if this is the first time you are saving the file, pick a location.

2. From the list of file types, select Excel Binary Workbook (*. xlsb).

   

Conserve your spreadsheet in binary (. xslb)format You can decrease your file size by saving your spreadsheet as a binary workbook(. xslb )rather of the default format(. xslx). The default format is XML based, which is essential if you’re using your information with third-party programs due to the fact that XML is an open standard. Nevertheless, for most functions, the binary format is sufficient and saves to a smaller sized file.

1. Go to Submit > Alternatives > Save.

2. Under Save workbooks, in the Save files in this format list, choose Excel Binary Workbook.

This choice sets binary format as the default.

If you want to keep the default to Excel Workbook (. xlsx) but conserve the existing file as binary, select the alternative in the Save As dialog box:

1. Go to Submit > Conserve As.

2. In the Save as type list, choose Excel Binary Workbook (*. xlsb).

Find out how to decrease the file size of your Excel spreadsheets.