Josh White's Jibwa.com - Excel file size reduction

Excel file size reduction

I have been working on an Excel 2003 Workbook with about 10 Sheets, and about 50 pages of visual basic scripts. The actual data content shouldn't be all that big because the worksheets are relatively small. I spent a lot of time trying to find ways to reduce the file size and nothing seemed to help until I found a posting on mrexcel.com about the

Microsoft Excel Excess Formatting Cleaner Add-in

It brought the file size down from about 3.5 to 2.5 mb, which was the best result I have managed to achieve thus far.

Fow whatever reason Microsoft didn't feel the need to say how to run the file cleaner, just install it. I found that somewhere, but I thought I would mention it here. Once you install it, which is explained on the download site, just open a workbook and then open the XlsFormatcleaner.xla file. Then

click File -> Clear Excess Formats (which should appear just below Close). Then save. You may need to unprotect all your worksheets first!

Be first to comment this article

Write Comment

Please keep the topic of messages relevant to the subject of the article. Personal verbal attacks will be deleted. Please don't use comments to plug your web site. Such material will be removed. Just ensure to Refresh your browser for a new security code to be displayed prior to clicking on the 'Send' button. Keep in mind that the above process only applies if you simply entered the wrong security code.
Name:
E-mail
Homepage
Title:
BBCode:
Comment:
Code:*
	I wish to be contacted by email regarding additional comments

Next >

[ Back ]

Under Construction

Jibwa.com is under construction. Watch out for broken links, missing pages, potholes and bulldozers. We apologize for the temporary inconvenience - Jibwa.com Staff

News and Updates

What to do when a website breaks

Once in a while you go to check out your personal website, or to log into your company web email and you can't. For the average person going about...
Read More ...

Find how much ram and processor your computer has

Most people remember buying their computer, and usually there was a point where you had to decide based on price what processor you wanted, and how ...
Read More ...

How to see home much storage/disk space you have left

Finding out how much space is left on your computer or how much space you have on your computer total is something very simple, but it can also ...
Read More ...

Jibwa and The Future of Computing

The staff and consultants at Jibwa LLC have been tinkering, working with, building, and developing software on compters since long before there was t...
Read More ...