[mso] Bloated Excel Files

I have a feeling that this is not an uncommon problem:

I have an Excel file of Sessions (i.e. Dates and times each of my clients
attend classes).  One of the fields has a drop down which draws information
from another file (my "Clients" list).  I have also added some pivot tables,
all of which depend on the one set of data (so not too much bloating there).
There are no macros (well, ones which I've created, anyway).

This file has grown excessively (to around 5Mb), so that when I go to save
it, it tells me curtly that the file wasn't saved - there's only about 3Mb
space left on the 64Mb pen drive I store it on.  I can get around this to a
certain extent by 'saving as' to hard disk and then copying back but I feel
that this is only a stop-gap solution.

There's only around 300 lines of data in it at the moment (though the
formulae extend, perhaps unnecesarily, to some 7000 lines). The point is
that it has grown inordinately at some point - possibly when I removed and
replaced the pen drive.  Is there any way of repairing what must be a
damaged file and restoring it to normal proportions?

I would rather like to preserve the way the file is set up as well as just
the data!

Andrew Kendon
(IT Trainer)
----------------------------------
Skills Training UK Ltd
Cherry Hinton Hall Learning Centre
Cherry Hinton Road
CAMBRIDGE CB1 8DW
----------------------------------
Tel.: 01223 458257
Mobile: 07815 301113
----------------------------------

*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in 
the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts: