Compress Excel File Format?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sarah Anderson - 19 May 2004 21:06 GMT

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.

Reply to this Message

David McRitchie - 19 May 2004 21:33 GMT

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.
[quoted text clipped - 8 lines]
> 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.

Reply to this Message

Ben - 19 May 2004 21:46 GMT

> 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

Reply to this Message

David McRitchie - 19 May 2004 22:55 GMT

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

> > Ultimate Zip is free. http://www.ultimatezip.com/download.htm
> > you can do a lot of things with it using right-click menus.
[quoted text clipped - 8 lines]
> regards,
> Ben

Reply to this Message

Lady Layla - 19 May 2004 22:04 GMT

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,
[quoted text clipped - 29 lines]
: > 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.

Reply to this Message

David McRitchie - 19 May 2004 22:25 GMT

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

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

Reply to this Message

pega2006 - 06 Oct 2006 17:08 GMT

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.

--
pega2006

Reply to this Message