PDA

View Full Version : File size too big



rama4672
03-26-2005, 03:50 PM
I have a file that is about 1mb in size, this file needs to be shared, when i share it the file jumps to 15mb, and the macros in the file that were taking 8 seconds to run now take about 80 secounds to run.
Is there anybody that can tell me why this happens and how to keep the file size down when it is shared.

Thank you for any help

Ian

Paleo
03-27-2005, 06:30 AM
Hi Ian,

it sounds very strange to me, but try to use this:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=83&PHPSESSID=fd38fc165a09b4c0969fee7b9f36a81d

rama4672
03-27-2005, 02:42 PM
Thanks for the reply Carlos
But i have already tried that, it does reduce file size when it is not shared, but when it is shared it hangs the system, i have to then press ctrl+atl and delete to get out of it.

Regards

Ian

Paleo
03-27-2005, 07:21 PM
Hi Ian,

check this out:
http://www.jegsworks.com/Lessons/numbers/design/share.htm
http://www.theofficeexperts.com/forum/archive/index.php/t-20.html

I believe that reading this two you will solve your problem.