View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Nayab Nayab is offline
external usenet poster
 
Posts: 62
Default Reduce File Size

On Jul 30, 1:40*pm, shakey1181
wrote:
Hi There,

I am trying to reduce the size of my file to around the 2MB mark. I have
followed all the advice i could find on the subject on this site, but still
can't get it below 4.5MB. I have tried:

1.CTRL+SHIFT+END and removing empty areas
2. Pasting all data as values, so there isn't a single formula in the file
3. Saving the file as .html. Although this did help with what was showing on
screen, it removed the group formatting which i need to keep in the file.

I have also minimised as much of the formatting as i can to still be able to
publish it.

Is there anything i am missing which might be able to reduce this file to
the magical emailable file size?

Thanks in advance


wat amount of data is there in your file? num of tabs and rows in each
tab?