Chart template and links

R

rukkie

Hi,

I have something "strange " (at least for me) going on ...

I have an xls workbook, containing some data sheets and also 3 chart
templates. These chart templates are copied via a macro to the output
xls with the statement :

Sheets(ChartName) _
.Copy Before:=Workbooks(targetfile.Window).Sheets(1)

When I now look to this chart template in the output xls I got a link
to the original xls workbook in which the macro is running. (I can see
that via EDIT>LINKS...)

Now I do NOT want that link to the originator xls workbook at all !

Is there anybody who knows how I can copy a chart template to another
workbook without the link (reference) to original workbook ?

Any help is very appreciated !!
 

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

Similar Threads

Copying chart templates to other workbook - Links 4
Embed the same Excel multiple times 0
Move Chart with Text 0
Filename Problem In a Macro 4
Interactive worksheets on the web 0
Link to another workbook & indirect 4
How to create absolute link to cell in another workbook (Excel 2003) 1
XL2010 messing up my templates 2

Top