For each tab, do a quick print preview to get an idea of how many page would
print. For the love of pete, just make sure you don't actually print the
file. In some cases, data gets accidentally left in odd places that you'd
typically never see, but inflate the file size. Also, excessive page-wide
formatting could result in some file inflation. Lastly, are there any hidden
sheets?
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"B. Graham" wrote:

I'm struggling with a multi-tab spreadsheet that's overly large, and I don't
think it should be.

The doc has a total of 12 tabs, but most have hardly any text. The one tab
that contains the vast majority of the data is 117KB. The document total size
is 20MB. If I take a few of the tabs I added and make them their own document
they are about 1MB in size for each tab.

I'm stumped. There's nothing special. No macros or anything like that, and
again, very little data. I simply created the tabs as copies of the first,
and then changed what I needed to.

Thanks for your help. This is mission critical for my job, and no one I know
has a clue.