Contents
Why is my file so large?
Excel has a “used range” for every sheet in your workbook. The larger this is, the bigger the file size becomes. Especially in older files, even if cells are blank and have no formatting, Excel may be treating them inside the used range, leading to a larger file size for no reason.
Why is my Excel file size suddenly so large?
There are many reasons for this happening, but one of the most common is a bug in Excel that bloats a file when you hide rows. Then select every row from about row 4 down and hide those rows. Now save the file again – suddenly our 8Kb file has increased by 340 times to almost 3Mb!
Why does the file size of an Excel workbook unexpectedly increase?
1 Symptoms. The file size of a Microsoft Excel workbook may unexpectedly increase exponentially. 2 Cause. This issue may occur if Excel closes unexpectedly. 3 Resolution. To resolve this issue, disconnect all users who are currently not using the workbook, save the workbook, and then close the workbook. 4 More Information.
Is the PDF file size too big in AutoCAD?
To translate this article, select a language. When plotting to PDF in AutoCAD, the resulting PDF file size is too large. The created PDF might be slow to open and manipulate. Install the latest updates for AutoCAD (see Install Updates, Add-ons, and Enhancements ).
How can I reduce the size of my existing file?
The procedure you mentioned is applicable for the new files to be opened, how could I reduce the size of my existing file. opened a new workbook, with no data, i ,only hide its rows and save, then unhide the same rows and save again, my file size increased to 2.5MB
Why is Excel 2007 file size so big?
Note Excel 2007 files are based on a combination of XML and compression, the file types are usually smaller than legacy XLS file types. However, this issue may occur in any of the versions of Excel that are listed in the “Applies to” section. This issue may occur if Excel closes unexpectedly.