PDA

View Full Version : Workbook size



Jeff_PD
08-23-2009, 08:31 AM
Lets try my luck with a second post.

I'm trying to understand what effects the size of workbooks in Excel 2003.

The workbook I'm on at the moment imports data from a couple of files and displays it in a useful format for non-technical users to look at, and it's 5Mb at the moment with data, formatting, instructions, code... When I simplified the conditional formatting in 20,000 cells the size whet up by a few Kb - I'd expected it to reduce.

Made me think that changes are appended to the workbook when it's saved but bits are not removed. And therefore there should be a way of tiding the file up and removing bits that are not used any more... Is there? I have seen the article in the knowledge base about removing unused lines so I will give that a go.

Cheers,
Jeff

Marcster
08-24-2009, 12:25 PM
Try this add-in from Microsoft:

http://www.microsoft.com/downloads/details.aspx?familyid=ecfd076c-b873-48cc-b842-da999c848c82&displaylang=en

Jeff_PD
08-24-2009, 01:28 PM
Cheers Marcster, I'll give it a go.