C
Chris Forgie
I want to copy a worksheet from one workbook
(DemoSheets.xls) to a newly created one (Right click on
the worksheet tab, click on Move or copy..., ...). This
seems to work fine when there are no charts on the
worksheet to being copied. However, when there is a
chart, Excel seems to be adding a name and reference to
Book1.xls for each name that was in DemoSheets.xls. These
names look like "='[Demo Sheets.xls]Gas Prices'!$B$5" when
they shouldn't be there at all.
The problem is experienced on Excel 2002 only when there
is a chart on the worksheet.
Is there any way to avoid getting this behavior?
(DemoSheets.xls) to a newly created one (Right click on
the worksheet tab, click on Move or copy..., ...). This
seems to work fine when there are no charts on the
worksheet to being copied. However, when there is a
chart, Excel seems to be adding a name and reference to
Book1.xls for each name that was in DemoSheets.xls. These
names look like "='[Demo Sheets.xls]Gas Prices'!$B$5" when
they shouldn't be there at all.
The problem is experienced on Excel 2002 only when there
is a chart on the worksheet.
Is there any way to avoid getting this behavior?