Compress Excel File Format?

S

Sarah Anderson

My regular Excel file is 29 KB. When I added 2 Pivot Tables and 1
Macro, the file ballooned to 2.51 MB.

I was able to use Zip to compress it back to 34 KB (amazingly). But I
don't want to manually do this all the time.

My Question: Is there a setting in Excel that can compress its Pivot
Table and Macros within the Excel file so I don't have to use Zip?

The reason I don't want to manually use Zip because some computers I
work with don't have Zip/Unzip and sometimes I'm in a rush to e-mail a
file. Manual Zipping seems like another unnecessary step.
 
D

David McRitchie

Hi Sarah,
Use Ctrl+End to check the last cell on your two =Pivot Tables,
and their source tables, if it looks unreasonable see
http://www.mvps.org/dmcritchie/excel/lastcell.htm#resetall
and report back (feedback, also include your version of Excel).

Don't know that it would affect the size, make sure you exit
out of each macro code module before exiting the VBE,
could affect speed.

Ultimate Zip is free. http://www.ultimatezip.com/download.htm
you can do a lot of things with it using right-click menus.
And the user can click on the .zip file and open the single
*.xls file directly. You have to unzip if there are several
files that use each other.
 
B

Ben

David said:
Ultimate Zip is free. http://www.ultimatezip.com/download.htm
you can do a lot of things with it using right-click menus.
And the user can click on the .zip file and open the single
*.xls file directly. You have to unzip if there are several
files that use each other.
Click to expand...

I was just checking it out and noticed that for companies it is no longer free:
"The license has changed to Shareware for commercial use and to Freeware for
private use."

regards,
Ben
 
L

Lady Layla

If you have XP Pro or Home there is a zip utility buuilt in that does well.


: Hi Sarah,
: Use Ctrl+End to check the last cell on your two =Pivot Tables,
: and their source tables, if it looks unreasonable see
: http://www.mvps.org/dmcritchie/excel/lastcell.htm#resetall
: and report back (feedback, also include your version of Excel).
:
: Don't know that it would affect the size, make sure you exit
: out of each macro code module before exiting the VBE,
: could affect speed.
:
: Ultimate Zip is free. http://www.ultimatezip.com/download.htm
: you can do a lot of things with it using right-click menus.
: And the user can click on the .zip file and open the single
: *.xls file directly. You have to unzip if there are several
: files that use each other.
: ---
: HTH,
: David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
: My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
: Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
:
: > My regular Excel file is 29 KB. When I added 2 Pivot Tables and 1
: > Macro, the file ballooned to 2.51 MB.
: >
: > I was able to use Zip to compress it back to 34 KB (amazingly). But I
: > don't want to manually do this all the time.
: >
: > My Question: Is there a setting in Excel that can compress its Pivot
: > Table and Macros within the Excel file so I don't have to use Zip?
: >
: > The reason I don't want to manually use Zip because some computers I
: > work with don't have Zip/Unzip and sometimes I'm in a rush to e-mail a
: > file. Manual Zipping seems like another unnecessary step.
:
:
 
D

David McRitchie

Hi Lady ...,
I don't have that version of Windows, is it under accessories.
I'd like to include that information. Is it automatically installed.

For those that would otherwise have to pay for an unzipper.
 
D

David McRitchie

Hi Bob,
Thanks I see that on their news and Faq pages for 3.0,
they didn't change their site logos that they offer
for you to put on your site, yet. I'm mark my
webnofee.htm page accordingly.
 
P

pega2006

Check out X-Shrink. This tool compresses Excel files and keeps all file
functionalities including .xls-format, including picture compression.
Check out www.x-shrink.com for more infos.
 
Top