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.

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.

I had this happen and it turned out to be a corrupted Excel file. You could
try this web address or similar ones.
http://www.diskdatarecovery.net/repair-excel-file/
Hope this takes care of the problem

JB


"B. Graham" <B. wrote in message
...
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.

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


Gord Dibben MS Excel MVP

On Tue, 22 Jul 2008 11:33:02 -0700, B. Graham <B.
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.