[mso] Re: Bloated Excel Files
- From: "adil shah" <adil_bhel@xxxxxxxxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: 1 Jul 2004 06:36:49 -0000
may be the data you have given in that file is the stroage capacity of 5 mb
better to check the Data
On Thu, 01 Jul 2004 Andrew Kendon wrote :
>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).
>//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
>*************************************************************
*************************************************************
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).
//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:
