Excel's Compress Pictures or deleting pictures doesn't seem work

G

Guest

Adding images to an excel workbook (specifically, dragging GIFs from IE,
don't know if it also happens with File > Insert) always increases the XLS
filesize. Deleting images, however, doesn't reduce the XLS file size at all.

Compress pictures doesn't either reduce filesize nor visibly compress the
images.

As a concrete example, I type monthly statistics info in an XLS sheet,
removing the old info each month. I drag (or copy-paste, the same) a chart
from a web application to the worksheet, and delete the previous month's
image. This incrementally doubles the XLS file size every month, even though
the final number of images is always the same and all images are simple GIF
charts, i.e. all have same sizes month-to-month:

First month: ~30kb
Second month: ~70kb
Third month: 140kb

I'm already at about 300kb unless I manually start from a copy of the first
month (the one that is 30kb) so as to get a 70kb file instead of starting
from the last version of the file (which would again duplicate the size).

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...6-ccb997f00904&dg=microsoft.public.excel.misc
 
S

Shailesh Shah

Hi Guidod,

Try "File Sizer" com-addins for excel-2000+ from below site for reduction in
file size.

http://in.geocities.com/shahshaileshs/

Compress pictures doesn't either reduce filesize nor visibly compress the
images.
It does reduce file size. Set resolution to web screen from Picture
Toolbar's compress setting.

Regards,
Shailesh Shah
http://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)


guidod said:
Adding images to an excel workbook (specifically, dragging GIFs from IE,
don't know if it also happens with File > Insert) always increases the XLS
filesize. Deleting images, however, doesn't reduce the XLS file size at all.

Compress pictures doesn't either reduce filesize nor visibly compress the
images.

As a concrete example, I type monthly statistics info in an XLS sheet,
removing the old info each month. I drag (or copy-paste, the same) a chart
from a web application to the worksheet, and delete the previous month's
image. This incrementally doubles the XLS file size every month, even though
the final number of images is always the same and all images are simple GIF
charts, i.e. all have same sizes month-to-month:

First month: ~30kb
Second month: ~70kb
Third month: 140kb

I'm already at about 300kb unless I manually start from a copy of the first
month (the one that is 30kb) so as to get a 70kb file instead of starting
from the last version of the file (which would again duplicate the size).

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/community/en-us/default.mspx?mid=5b2b8571-69
9e-4980-8946-ccb997f00904&dg=microsoft.public.excel.misc
 

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