File sizes

bolo

Active Member
Joined
Mar 23, 2002
Messages
423
Hi i was wondering if anyone can tell me why the file sizes in xl vary so much. I have this one work book i am working on that varies between 800k to 1500K. I am not adding any substantial data to the workbook, just messing with code. If i try saving the workbook a couple of the times the file size changes.

Thanks. Keep up the good work.
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

Juan Pablo González

MrExcel MVP
Joined
Feb 8, 2002
Messages
11,959
No idea, I get the same. I believe it's because of the "garbage" that gets included in the file from the VBA running and editing, because if you export everything (Modules, Forms, Class modules, etc.), and reimport them, the file should change dramatically !
 

Jack in the UK

Well-known Member
Joined
Feb 16, 2002
Messages
3,215
Hi

You say MESSING with code your need to clean out the VBA as Juan says, and clean the data sheets will be trashed, CLEAR contence to ever un data cell and cell

Few other tricks, delete unused Wk Sheets, and so on

Sounds you have baggage all over the place.

HTH
 

Ekim

Well-known Member
Joined
Jun 30, 2002
Messages
1,416
You may want to look at these sites:

An article on "Worksheet Bloat".
http://www.beyondtechnology.com/tips019.shtml

Also recommended is
http://www.ozgrid.com/Excel/ExcelProblems.htm


In addition, you may want to look at Rob Bovey's code cleaner, a free utility that can be downloaded from:

http://www.appspro.com

To quote from Mr.Bovey's web site:

"During the process of creating VBA programs, a lot of "junk" builds up in your files. If these files aren't cleaned periodically, you will begin to experience strange problems caused by this extra baggage. Cleaning a project involves exporting the contents of all its VBComponents out to text files, deleting the components, then importing the components back from the text files."

HTH

Mike
This message was edited by Ekim on 2002-10-06 22:53
 

Forum statistics

Threads
1,143,617
Messages
5,719,740
Members
422,242
Latest member
hishamkhatri

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top