Compress Excel File Format?

[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.

 

[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.

 

[Ben]

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.

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

 

[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.
:
:
: > 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.
:
:

 

[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.

 

[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.