I have a master file with bubble charts. In a loop, the 2 sheets with
the charts and the chart data get copied to a new workbook, saved with
another name and links to the master file are broken. When this
happens, the last number on my bubble size gets turned into a zero.
Does anyone know how to prevent this?

You are probably best off asking the person who gave you the code. If
you wrote it yourself, you may want to share the relevant portions of
the code. If you do so, please post the code in the text of the
message; many people, including myself, will not download or open a
file.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <(E-Mail Removed)>,
(E-Mail Removed) says...
> I have a master file with bubble charts. In a loop, the 2 sheets with
> the charts and the chart data get copied to a new workbook, saved with
> another name and links to the master file are broken. When this
> happens, the last number on my bubble size gets turned into a zero.
> Does anyone know how to prevent this?
>