Compress an Excel File

[Mandy]

I have an excel file that is 36 meg. Do you know how to
compress the file? When I zip the file it drops to 3meg
so I know it can be compressed.

I beleive the file has become large due to the constent
changes I need to make to the file.

Help Please.

 

[Ron de Bruin]

Hi Mandy

Maybe this will help?
http://www.contextures.com/xlfaqApp.html#Unused

You can use Rob Bovey's Code cleaner to clean up your code
http://www.appspro.com/utilities/utilities.asp

 

[Mandy]

Ron,

I read the 1st link and there was nothing about
compressing an excel file. The 2nd link did not work,
could you please resend the link.

Thanks.

 

[Lady Layla]

The first link was in regards to making sure your file was not bloated. Once
you remove the bloat, the file may be significantly smaller. In regards to
Compressing an Excel file, use a utility like Win Zip or if you have Windows XP,
use it's integrated file compressor




: Ron,
:
: I read the 1st link and there was nothing about
: compressing an excel file. The 2nd link did not work,
: could you please resend the link.
:
: Thanks.
:
: >-----Original Message-----
: >Hi Mandy
: >
: >Maybe this will help?
: >http://www.contextures.com/xlfaqApp.html#Unused
: >
: >You can use Rob Bovey's Code cleaner to clean up your
: code
: >http://www.appspro.com/utilities/utilities.asp
: >
: >
: >
: >--
: >Regards Ron de Bruin
: >http://www.rondebruin.nl
: >
: >
: : >> I have an excel file that is 36 meg. Do you know how
: to
: >> compress the file? When I zip the file it drops to
: 3meg
: >> so I know it can be compressed.
: >>
: >> I beleive the file has become large due to the constent
: >> changes I need to make to the file.
: >>
: >> Help Please.
: >
: >
: >.
: >

 

[Ron de Bruin]

I forgot that Rob change his links

http://www.appspro.com/Utilities/CodeCleaner.htm

 

[Romanian37]

Try the below link to a previous post - regarding reducing file size
may help

Will

http://www.excelforum.com/t181649-

 

[Mandy]

Lady Layla,

I have windows XP and I did a search on the integrated
file compressor and I can't find it to use it.

Can you help.

 

[Lady Layla]

Go to My Computer, find the file, right click on it, go to send to, select
compressed folder, follow the wizard.


: Lady Layla,
:
: I have windows XP and I did a search on the integrated
: file compressor and I can't find it to use it.
:
: Can you help.
:
: >-----Original Message-----
: >The first link was in regards to making sure your file
: was not bloated. Once
: >you remove the bloat, the file may be significantly
: smaller. In regards to
: >Compressing an Excel file, use a utility like Win Zip or
: if you have Windows XP,
: >use it's integrated file compressor
: >
: >
: >
: >
: message
: >: >: Ron,
: >:
: >: I read the 1st link and there was nothing about
: >: compressing an excel file. The 2nd link did not work,
: >: could you please resend the link.
: >:
: >: Thanks.
: >:
: >: >-----Original Message-----
: >: >Hi Mandy
: >: >
: >: >Maybe this will help?
: >: >http://www.contextures.com/xlfaqApp.html#Unused
: >: >
: >: >You can use Rob Bovey's Code cleaner to clean up your
: >: code
: >: >http://www.appspro.com/utilities/utilities.asp
: >: >
: >: >
: >: >
: >: >--
: >: >Regards Ron de Bruin
: >: >http://www.rondebruin.nl
: >: >
: >: >
: >: : >: >> I have an excel file that is 36 meg. Do you know
: how
: >: to
: >: >> compress the file? When I zip the file it drops to
: >: 3meg
: >: >> so I know it can be compressed.
: >: >>
: >: >> I beleive the file has become large due to the
: constent
: >: >> changes I need to make to the file.
: >: >>
: >: >> Help Please.
: >: >
: >: >
: >: >.
: >: >
: >
: >
: >.
: >

 

[Lady Layla]

And if a previous version of Excel is not available?


: Try the below link to a previous post - regarding reducing file size -
: may help
:
: Will
:
: http://www.excelforum.com/t181649-s
:
:
: ---
: Message posted
: