Chartīs source data

[krpk67]

Hi!

When I have made a chart with source data from another Excel workbook, and an example I send it to my friend for use. The correct source disappear from chart's and starting to point to on his own home directory.

How I can lock those like that, them are not moving/changing anything else, when it use another computer?

Many thanks for your advise, and hope making clear myself.

BR, PK

[darkyam]

Best ways I can think of are to either save as a different name before you send and then break the links from the chart to the data or have the data in your spreadsheet.