reducing file size when done

J

JohnE

I have now completed the workbook and making the modules
under 64k. The file is about 4 megs (w/o data) in size
and when emailing, it could be a hindrance. In Access
you can compact and repair. In Excel there is nothing
like that.
Does anyone have any "tricks" or thoughts on how to make
a file smaller?
Thank in advance to anyone responding.
*** John
 
M

Maurice

Depending on what is involved in your workbook, you could copy eac
sheet into a new workbook and make an exact copy of the original. Tha
has worked for me in the past

You could try www.asap-utilities.com and use the various utilites t
clear out unwanted bits and pieces


The final way i know of is to ZIP the file down, i've just done on
from 8Mb to under 1Mb for the purpose of emailin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top