Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying chart templates to other workbook - Links
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 Befo=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 EDITLINKS...) 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 !! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying chart templates to other workbook - Links
Copy the source data as well, but copy the two sheets together.
Sheets(Array(ChartName,DataName)) _ .Copy Befo=Workbooks(targetfile.Window).Sheets(1) -- Regards, Tom Ogilvy "rukkie" wrote: 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 Befo=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 EDITLINKS...) 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 !! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying chart templates to other workbook - Links
Hi,
are there no other possibilities than copying also the source data ? People for who the output is generated are not interested in this source data ...Otherwise I could give them also the originator xls workbook and so EXCEL will never complain about "File not found" ... I just want to avoid that they got the "overload" of sheets/data which are not interesting for them ... I hope you understand ... On 26 jan, 17:25, Tom Ogilvy wrote: Copy the source data as well, but copy the two sheets together. Sheets(Array(ChartName,DataName)) _ .Copy Befo=Workbooks(targetfile.Window).Sheets(1) -- Regards, Tom Ogilvy "rukkie" wrote: 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 Befo=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 EDITLINKS...) 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 !! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying chart templates to other workbook - Links
http://support.microsoft.com/kb/213443/en-us
XL2000: Visual Basic Macro to Break Chart Links you would do this after you copy the chart. The other alternative would be to copy as picture and paste the chart in as a picture. -- Regards, Tom Ogilvy "rukkie" wrote: Hi, are there no other possibilities than copying also the source data ? People for who the output is generated are not interested in this source data ...Otherwise I could give them also the originator xls workbook and so EXCEL will never complain about "File not found" ... I just want to avoid that they got the "overload" of sheets/data which are not interesting for them ... I hope you understand ... On 26 jan, 17:25, Tom Ogilvy wrote: Copy the source data as well, but copy the two sheets together. Sheets(Array(ChartName,DataName)) _ .Copy Befo=Workbooks(targetfile.Window).Sheets(1) -- Regards, Tom Ogilvy "rukkie" wrote: 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 Befo=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 EDITLINKS...) 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 !! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying chart templates to other workbook - Links
Another possibility with XP or later (suggested by Jon Peltier elsewhere)
Edit Links Break Link The link Tom referred you to should work fine with typical smallish charts, without special number formats in say axes or data labels, no linked titles or labels, and won't work for all types of charts. There's also a max 255 characters limit (incl additional ancillary characters) per set of values and can be less than 255, though I guess that's unlikely in a template chart. If neither Tom's link nor Jon's suggestion work fully as expected revert back, I have something else you could try. Regards, Peter T "rukkie" wrote in message oups.com... Hi, are there no other possibilities than copying also the source data ? People for who the output is generated are not interested in this source data ...Otherwise I could give them also the originator xls workbook and so EXCEL will never complain about "File not found" ... I just want to avoid that they got the "overload" of sheets/data which are not interesting for them ... I hope you understand ... On 26 jan, 17:25, Tom Ogilvy wrote: Copy the source data as well, but copy the two sheets together. Sheets(Array(ChartName,DataName)) _ .Copy Befo=Workbooks(targetfile.Window).Sheets(1) -- Regards, Tom Ogilvy "rukkie" wrote: 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 Befo=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 EDITLINKS...) 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 !! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying and pasting links within the same workbook | Excel Worksheet Functions | |||
Chart Location Impact On Links When Copying To New Workbook | Charts and Charting in Excel | |||
copying a pivot chart to another workbook | Charts and Charting in Excel | |||
Need button in workbook that links directly to a chart. | Excel Discussion (Misc queries) | |||
Chart links not updated when copying two worksheets | Charts and Charting in Excel |