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


"David McRitchie" wrote in message
...
: 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...l.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
:
: "Sarah Anderson" wrote ...
: 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.
:
: