Most valuable professional
  • Hot Topics

Excel Avoiding The Creation of A Bloated Excel File

I have this code that will: a) create a new workbook b) filter the source data in a second open workbook c) copy the filtered results to the empty worksheet (ws_data) in the new workbook The code runs well, however, the resulting new file is heavily bloated! With a (visible) range of data occupying A1:W71, the file is 20059kb in size. CTRL-END shows the last cell of the range to be W1048208. Is anyone able to comment on what may be causing this bloat. It must be the way data is being copied and pasted between workbooks. The source file is only 149kb. Is there a better way to to this avoiding whatever is causing the bloat? If not, a means to reduce the size of the file to a more manageable one. Deleting the rows each time a new workbook is created may be an awkward and time consuming task, so I'd prefer to take a preventative approach rather than reactive if I could. Code: For

This question generated 17 answers. To proceed to the answers, click here.

This thread is current as of February 23, 2017.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel