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
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