Sudden jump in file size

N

Naomi

He everyone,

I created a workbook that contained several charts and
some data but not that much and it was about 400k. I then
added another chunk of data (perhaps 3 worksheets with
between 100 and 500 lines of stuff) and the file size
jumped to 35MEG!

When I zip it it goes back down to about 800k...

Any ideas what is going on?
 
L

Lady Layla

If Excel has set the "used" range wrong, then you will get a lot of bloat. You
need to look at "used" ranges on all your sheets, look at the complexity of the
data -- lot of formulas or just data, look at how the sheets are interacting --
are formulas linking sheets?

: I mighjt be being silly but I can't see much about file
: size there? Thanks tho :)
:
:
: >-----Original Message-----
: >Hi
: >maybe the following will help you:
: >http://www.contextures.com/xlfaqApp.html#Unused
: >
: >--
: >Regards
: >Frank Kabel
: >Frankfurt, Germany
: >
: Newsbeitrag
: >: >> He everyone,
: >>
: >> I created a workbook that contained several charts and
: >> some data but not that much and it was about 400k. I
: then
: >> added another chunk of data (perhaps 3 worksheets with
: >> between 100 and 500 lines of stuff) and the file size
: >> jumped to 35MEG!
: >>
: >> When I zip it it goes back down to about 800k...
: >>
: >> Any ideas what is going on?
: >>
: >>
: >
: >.
: >
 
N

Naomi

There isn't that much complexity in terms of the data and
formulae etc. How do I check the 'used' ranges?

Thx.
 
Top