[mso] Re: Excel Bloat
- From: David Good - ANSYS Europe <david.good@xxxxxxxxx>
- To: "'mso@xxxxxxxxxxxxx'" <mso@xxxxxxxxxxxxx>
- Date: Thu, 5 Dec 2002 13:18:07 -0500
Depends how much data you have and what kind of format it's in.
If you wanted to guarantee everything's clean I'd start to copy and paste
the data to a new workbook - this way you'll clear out any other corruption
that may be hiding somewhere.
You can speed this up by using CTRL-* to high-light regions of data (CTRL-*,
CTRL-C, switch to new sheet, rename sheet CTRL-V etc), but make sure you
don't have any blank columns of rows - this will stop the CTRL-* from
working.
This may be long winded - but it will clear out all the gremlins - be them
mis-defined regions, corrupt cells, or rogue macros. If the workbook's still
bloated after this then my only guess is a (conditional) formatting
corruption (if that ever happens?).
Alternatively I'm sure Excel has a Select-Special>Blank cells somewhere
where you could select all blank cells, then clear-contents. However I can't
find it (...end of day fatigue I guess LOL)
HTH,
Dave.
-----Original Message-----
From: Roy Crockett [mailto:Roy.Crockett@xxxxxxxx]
Sent: 05 December 2002 17:59
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Excel Bloat
Yes, Excel file. Many sheets go well beyond where I would think they should
have... IV - 65,000~ and there are 13 sheets doing this.
Thanks, what do I do if clear>all doesn't change the Ctrl+a from going to
the same end? I'm using Excel 2002.
Roy
> -----Original Message-----
> From: mso-bounce@xxxxxxxxxxxxx
> [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of Linda F. Johnson
> Sent: Thursday, December 05, 2002 11:07 AM
> To: mso@xxxxxxxxxxxxx
> Subject: [mso] Re: Excel Bloat
>
>
>
> A program? Or a file?
>
> I assume you mean an Excel file? What version of Excel?
*************************************************************
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?Subject=unsubscribe
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?Subject=unsubscribe
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:
