Upload Fails for Xlxs File Type Excel Not Installed

Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013 More...Less

If the file size of your spreadsheet is too large, endeavour the following tips to brand it more manageable.

Save your spreadsheet in binary (.xslb) format

You can reduce your file size by saving your spreadsheet every bit a binary workbook (.xslb) instead of the default format (.xslx). The default format is XML based, which is important if yous're using your information with tertiary-party programs because XML is an open standard. However, for most purposes, the binary format is sufficient and saves to a smaller file.

1. Get to File > Options > Relieve.

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

   

This option sets binary format as the default. If you want to go along the default to Excel Workbook (.xlsx) but salvage the current file every bit binary, select the option in the Save Every bit dialog.

Notation:If the file is located in a SharePoint library, you lot might non see the Save As pick. If this is the case, you can save a copy to your local bulldoze, relieve that re-create as a binary, and and then replace the original file with the new binary.

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

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

   

Save your spreadsheet in binary (.xslb) format

You can reduce your file size by saving your spreadsheet as a binary workbook (.xslb) instead of the default format (.xslx). The default format is XML based, which is important if yous're using your data with third-party programs considering XML is an open standard. Withal, for near purposes, the binary format is sufficient and saves to a smaller file.

1. Go to File > Options > Salvage.

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

This option sets binary format as the default.

If you lot want to keep the default to Excel Workbook (.xlsx) but save the electric current file every bit binary, select the option in the Salvage As dialog box:

1. Go to File > Save Equally.

2. In the Salvage as blazon list, select Excel Binary Workbook (*.xlsb).

Reduce the number of worksheets

If you have worksheets with data that you're not using—and that don't contain whatever formulas you're using—delete them from the spreadsheet.

The more data points you have in your workbook, the larger your file size will be. Removing unused information volition reduce your file size.

Save pictures at lower resolutions

1. Become to File > Options > Avant-garde.

2. Under Paradigm Size and Quality, do the following:

   • Select Discard editing data. This option removes stored data that'due south used to restore the image to its original state later on it's been edited. Note that if y'all discard the editing data, yous won't exist able to restore the paradigm.

   • Brand sure that Practice non compress images in file is non selected.

   • In the Default resolution listing, select a resolution of 150ppi or lower. In most cases, you won't need the resolution to be college than that.

Shrink pictures

1. Select a flick in your document. The Picture Format tab appears on the ribbon.

2. On the Motion-picture show Format tab, in the Adapt group, select Compress Pictures.

3. Under Compression options, do the following:

   • To shrink all the pictures in the file, clearApply only to this motion picture. If this selection is selected the changes you make here volition only affect the selected picture.

   • Select Delete cropped areas of pictures. This pick removes the cropped picture data, but note that y'all won't be able to restore it.

4. Under Resolution, practice the post-obit:

   • Select Use default resolution.

     

Don't salvage the pivot enshroud with the file

If your spreadsheet contains a pivot table, yous tin reduce the file size by not saving the pivot table source information enshroud with the file and instead having the data cache refresh when yous open the spreadsheet.

1. Select any cell in the pivot table.

2. On the PivotTable Analyze tab, in the PivotTable group, select Options.

3. In the PivotTable Options dialog box, select the Data tab, and practice the post-obit:

   • Uncheck Save source data with file.

   • Select Refresh data when opening the file.

     

See Also

Reduce the file size of your PowerPoint presentations

Reduce the file size of your Word documents

Need more aid?

brimhimakinecity.blogspot.com

Source: https://support.microsoft.com/en-us/office/reduce-the-file-size-of-your-excel-spreadsheets-c4f69e3a-8eea-4e9d-8ded-0ac301192bf9

Share this post