[mso] Re: Bloated Excel Files

  • From: "Melissa Miller" <melmiller@xxxxxxxxxxxxxx>
  • To: <mso@xxxxxxxxxxxxx>
  • Date: Thu, 1 Jul 2004 07:38:52 -0400

The size is 37.5 kb. I can go into Excel Viewer and SEE where their is
supposed to be drop downs but they are not their, when i uswe the viewer and
try to go to Open for editing, it says Excel 97 is not installed, BUT it is
becuz I use it daily, and this file opens up in MS Works spreadsheet but no
drop downs just the file.

Not sure what ya'll mena by "pen drive" I tried deleting and re downoading
from the email my boss sent.

Nothing is working!

Please help, I do know computers, quite well but this has me confused.

Melyssa
----- Original Message ----- 
From: "adil shah" <adil_bhel@xxxxxxxxxxxxxx>
To: <mso@xxxxxxxxxxxxx>
Sent: Thursday, July 01, 2004 2:36 AM
Subject: [mso] Re: Bloated Excel Files


> 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
> *************************************************************
>

*************************************************************
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: