XL2000 - Excessive file size

[cbs]

I have a workbook with 5 sheet. No sheet has more than
200 rows and 20 columns of data (most are less) . There
are multiple formulas in the various sheets. These are
simple sumif w/nested if statements. The file size was
about 201K bytes. I recently added a 6th sheet that was
very similar in size and nature to the others. When I
saved it, the new version jumped up to close to 5M bytes
in size.

The workbook has no externl links, macros, VB. It is
simply $ values and formulas. One of the sheets
represents master data that the others make reference
too. I also check that the track changes option is turned
off.

Can any one explain why the workbook is became so large
and is there any way to get it back to a size that is
represntative of that data that it contains?

 

[Gord Dibben]

cbs

Ususally a result of Excel thinking the Used Range on a sheet(s) is larger
than it really is.

See Debra Dalgleish's site for info on how to reduce.

http://www.contextures.on.ca/xlfaqApp.html#Unused

Gord Dibben Excel MVP

 

[SheGeek]

I once made a spreadsheet that used almost all of the columns in 3
sheets - to calculate RF readings from three overlapping sources. I
was shocked when the file size was just over 20MB. Infact I didn't
even think about it until I tried to email it LOL!

SheGeek