Excel file share size

But you need to be a bit cautious when working with the XLSB format. Based on what I heard from people and read on many forums, a lot of people prefer to use XLSB as the file format when it comes to using Excel. Here is a good article on understanding the XLSB format.

Here are the steps to quickly convert formulas to values in Excel:. I created an Excel file with 2. If you work with Excel files that have images in it, you need to optimize these images and make sure the size is less. The problem with images is that as you compress these, there is also a reduction in quality, which you may not want.

When working with images, the best way to keep the size of your Excel file low is by compressing the images before you insert it into Excel. Below is the screenshot where I was able to compress an image with the size of 3. Once you have uploaded these compressed images to Excel, you can further compress it using the inbuilt option in Excel. This would depend on the image as well. An image that is already compressed may not lead to a huge size reduction.

If you work with Pivot tables and struggle with large Excel files, knowing about Pivot cache can be useful. When you create a pivot table using a data set, Excel automatically creates the Pivot Cache. When you make any changes in the Pivot Table, it does not use the data source, rather it uses the Pivot Cache.

While you think that you are directly linked to the source data, in reality, you access the pivot cache and not the source data when you make changes in the pivot table. So as soon as you create a Pivot table, you will notice that the size of the Excel file increase. Doing this will make your Excel file lighter, and you have a way to recreate the Pivot cache when you need it the next time.

Another way reduce Excel file size is to delete the source data of a Pivot Table and keep the Pivot Cache only. To do this, just delete the data either by deleting the data or the worksheet that has the data. You can then share this zipped file to via email, and the person receiving this can unzip the file and use the Excel workbook.

This technique works better for files that are in the MB range. As the file size increases, the percentage reduction is not very high. Data formatting such as applying a background color, or adding borders, or changing font style can all add to the file size. Below are the sizes of two Excel workbooks, one with 2. You can see the difference between the two files is not that huge although it does make an impact when you have a lot of data.

Removing it can save you some disk space. Just like regular data formatting, conditional formatting also adds to the file size. However, based on my tests, I noticed that the difference is less unless you have multiple rules applied to multiple sheets with huge datasets. Conditional formatting is volatile and whenever there is any change in the worksheet, it recalculates.

This can lead to a slower workbook. Microsoft Enterprise. Browse All Community Hubs. Turn on suggestions. Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. Showing results for. Show only Search instead for. Did you mean:.

Sign In. New Contributor. Going by the article it's up to 50mb? Onedrive as a whole is GB. Labels: Labels: Excel Office Tags: OneDrive. Chinny This file is too big If you use Microsoft Edge or a recent version of other popular web browsers, you can upload files to OneDrive that are up to GB in size. Select Discard editing data. This option removes stored data that's used to restore the image to its original state after it's been edited. Note that if you discard the editing data, you won't be able to restore the image.

In the Default resolution list, select a resolution of ppi or lower. In most cases, you won't need the resolution to be higher than that. Select a picture in your document. The Picture Format tab appears on the ribbon. To compress all the pictures in the file, clear Apply only to this picture.

If this option is selected the changes you make here will only affect the selected picture. Select Delete cropped areas of pictures. This option removes the cropped picture data, but note that you won't be able to restore it. Select Use default resolution. If your spreadsheet contains a pivot table, you can reduce the file size by not saving the pivot table source data cache with the file and instead having the data cache refresh when you open the spreadsheet.

In the PivotTable Options dialog box, select the Data tab, and do the following:. Select Refresh data when opening the file. Reduce the file size of your PowerPoint presentations.