[mso] Re: Bloated Excel Files
- From: "Anne Robson" <anne.robson2@xxxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Thu, 1 Jul 2004 09:34:49 +0100
Andrew
If you are running the file direct from the pen drive this is likely to
be related to the spare memory on that drive - don't forget that there
will be a temp file created when you open the worksheet/s and they take
up space on your pen drive until the file is saved and/or closed.
The *logical* solution would be to transfer the files concerned to your
hard drive, check the pen drive for surplus temp files and anything else
you don't need to store and then re-save or copy back on the pen drive
in due course.
HTH
Anne
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of Andrew Kendon
Sent: 30 June 2004 22:52
To: Mso@Freelists. Org
Subject: [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?
Andrew Kendon
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.712 / Virus Database: 468 - Release Date: 27/06/2004
*************************************************************
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:
