What makes excel file large

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. Reduce the file size of your Word documents. Save your spreadsheet in binary. Need more help? Expand your skills. Get new features first. That was why my files were in the tens of megs. Thank you. Dear Will, Thanks for spotting this! We added two extra steps so you can see how to effectively change your file extension to ZIP.

You can use Ctrl-End to find the outmost cell that is being saved. Hi Bart, Thanks for the tip! I deleted all 3 and the used range is now down to about 50 columns, then saved the file.

This resulted in no reduction zero k in file size. I verified that the used range is now correct and this bloated columns are gone, so why no change in size? Fantastic Post, thank you very much.

The ZIP file method is incredible, I will not forget that going forward. We went from 46MB to KB. I tried 1st method but xecel file size increased 12MB to MB and system fully slow. But then I follow all series wise finally reduce excel file size. Direct access to content Direct access to menu Back. Do you want to know how to reduce your Excel file size? Table of Contents Hide. First, audit your large Excel file. Tip 1: Remove conditional formatting. Sometimes you work on an Excel file with one or more Worksheets and when you save, you notice the saving is slower, takes longer to move around or open the right-click menus, etc.

All these are symptoms that the file has a size problem - in-memory or on disk. Let's have a look at how you can check the size of your Excel workbook, how to inspect the worksheets to figure out which worksheet is too large or is causing the size issue, then look at a few cool keyboard shortcuts to help you move around and diagnose the problem and make your excel spreadsheet smaller. Finally, with a few keystrokes, I show you how you can clear the problem, reduce your excel file size and delete unnecessary or blank rows and columns in your Excel workbook so that it is optimized.

To further investigate the problem and see some data about your entire workbook, you can go to the Workbook statistics in the Review tab in Excel, and look at the workbook statistics. This should show you what's going on in your current worksheet as well as how many cells with data are in your workbook, how many worksheets you have and other useful info:.

The first thing I would do is check which worksheets I don't need and delete them. Whether they are blank or you think they are blank, if you don't need them, remove them. I'm trying to do this, and I'm running into the little issue that many of my rows are not un-hiding themselves when I tell them to. I finally figured out the hidden-cell glitch Anyway, JB was right!

I deleted the needless formulae and formatting, and now the file loads in about 10 seconds! What did the file size drop to? A little over 7MB. VERY helpful - thank you!

I got a simple solution. I copied a sheet then delete the original sheet saved. Originally Posted by JBeaucaire.