Cloning objects between workbooks without external reference

[mbobro]

hi,

Is that possible to make it manually or via VBA to clone (copy) whole
different objects (for example charts, sheets) that will copy all the
data and formatting but WITHOUT the external links?

Sometimes I need to duplicate a formula of a chart in the new workbook
and if I copy if it will keep reference to the external original
workbook. I'd like to keep the format and all the references, but to
keep the references local in the new workbook.

The time consuming solution is to modify all the series on such a chart
manually, but I believe in the better and faster solution.


Thanks in advance,


Michal

 

[Max]

Try Jon Peltier's page for delinking chart data at:

http://peltiertech.com/Excel/ChartsHowTo/DelinkChartData.html

Scroll down and look for:

Sub DelinkChartFromData()
Sub DelinkChartFromLotsOfData()

 

[kkknie]

If the chart is an object in the worksheet with the data (rather than
separate sheet), you can copy the entire sheet with the chart, the
paste the new data into the copied sheet.

For example, say you have a sheet name Sheet1 with data and a chart an
another sheets called Sheet2 with just new data. You could make a cop
of sheet1 (call it sheet3), then paste the data from Sheet2 into th
new Sheet3.

Other than this, the only option I can think of is a Macro solutio
that might take quite a while to write.

K

Note: See the post before mine. Looks like someone has figured it out