Reduce the size of an Excel workbook

Welcome back

In Microsoft Office for world

A new topic of interest to all users of Microsoft Excel

In today's article, we will learn about two very effective ways to reduce the size of the Excel file

Often when I enter macros or modules in Excel with some other formats such as formulas, formulas and conditional formatting

The size of the excel file increases in a large way, which makes it difficult to deal with the file, very slow and not easy to save

Which requires us to intervene quickly and urgently to save our Excel file from damage and collapse?

In many cases, you can reduce the size of a workbook drastically, especially a workbook that contains modules that you has heavily edited, because Excel doesn't do a good job of cleaning up after itself. To clean up the mess that Excel leaves behind:

Therefore, in this tutorial, we will give you two ways to reduce the size of the Excel file as follows:


1- Save your workbook.

2- Select a module or user form in the project window.

3- Right-click and choose "Remove" from the shortcut menu.

4- When asked if you want to export the unit, click yes.

5- Repeat steps 3 and 4 for each user module and form, keeping track of the modules and forms you are removing.

6-Choose File Import File to import all the modules and models you have deleted.

7-Save the workbook again.

You will usually find that the new workbook is much smaller than it was. Another way to reduce the file size of a workbook is as follows:

1-Activate your workbook.

2- Choose File Save as Web Page, and make sure to use the Entire workbook option.

3- Close your workbook.

4-Use Open File to open the HTML file you saved in step 2.

4- Use File Save As, and resave the workbook as a standard XLS file.

In most cases, you will find that the file size is smaller. 

Emad ghazi
كاتب المقالة
كاتب ومحرر اخبار اعمل في موقع عالم الاوفيس .

جديد قسم : مهارات الاكسل

إرسال تعليق