Every time I autopublish a selection within a worksheet, which includes a
chart and text boxes excel creates a copy of the chart and text boxes in bmp
format and places it on top of the actual chart and text box. If I save 5
times I create 5 bitmaps. I can select and delete them.
How can i prevent Excel from doing this?

Mike,
Funny, I posted the same question. (see below).
Did you get any results on this, it's driving me up the wall!



I've been using AUTOPUBLISH to save a graphs page of a workbook as an MHT
file (single page web file) - a really nice feature that allows me to publish
daily data to the whole of the company, a lot of whom don't have Excel.

However, I've found that after clicking save, each of my graphs ends up with
an image object of the graph itself dumped on top of it. When I first noticed
it, the actual graph was buried several objects deep. These look like they're
probably the JPG images that were used in the webpage construction because
they're slighty fuzzy.

This only happens when I hit save (and the autopublish runs) if I'm on a
different worksheet.

Why does this happen and how can I stop it from happening?

Thanks,

------
&e7




------
&e7


"Mike" wrote:

Every time I autopublish a selection within a worksheet, which includes a
chart and text boxes excel creates a copy of the chart and text boxes in bmp
format and places it on top of the actual chart and text box. If I save 5
times I create 5 bitmaps. I can select and delete them.
How can i prevent Excel from doing this?

&e7
I have received no replies on this issue.


"&e7" wrote:

Mike,
Funny, I posted the same question. (see below).
Did you get any results on this, it's driving me up the wall!



I've been using AUTOPUBLISH to save a graphs page of a workbook as an MHT
file (single page web file) - a really nice feature that allows me to publish
daily data to the whole of the company, a lot of whom don't have Excel.

However, I've found that after clicking save, each of my graphs ends up with
an image object of the graph itself dumped on top of it. When I first noticed
it, the actual graph was buried several objects deep. These look like they're
probably the JPG images that were used in the webpage construction because
they're slighty fuzzy.

This only happens when I hit save (and the autopublish runs) if I'm on a
different worksheet.

Why does this happen and how can I stop it from happening?

Thanks,

------
&e7




------
&e7


"Mike" wrote:

Every time I autopublish a selection within a worksheet, which includes a
chart and text boxes excel creates a copy of the chart and text boxes in bmp
format and places it on top of the actual chart and text box. If I save 5
times I create 5 bitmaps. I can select and delete them.
How can i prevent Excel from doing this?

Me neither :(

I've switched removed the autopublishing and it still creates the bitmaps
from time to time. Since it's Friday afternoon, I'm going to have another
look into this.

------
&e7


"Mike" wrote:

&e7
I have received no replies on this issue.


"&e7" wrote:

Mike,
Funny, I posted the same question. (see below).
Did you get any results on this, it's driving me up the wall!



I've been using AUTOPUBLISH to save a graphs page of a workbook as an MHT
file (single page web file) - a really nice feature that allows me to publish
daily data to the whole of the company, a lot of whom don't have Excel.

However, I've found that after clicking save, each of my graphs ends up with
an image object of the graph itself dumped on top of it. When I first noticed
it, the actual graph was buried several objects deep. These look like they're
probably the JPG images that were used in the webpage construction because
they're slighty fuzzy.

This only happens when I hit save (and the autopublish runs) if I'm on a
different worksheet.

Why does this happen and how can I stop it from happening?

Thanks,

------
&e7




------
&e7


"Mike" wrote:

Every time I autopublish a selection within a worksheet, which includes a
chart and text boxes excel creates a copy of the chart and text boxes in bmp
format and places it on top of the actual chart and text box. If I save 5
times I create 5 bitmaps. I can select and delete them.
How can i prevent Excel from doing this?