vba - Convert linked excel into embedded excel -

vba - Convert linked excel into embedded excel -

i have ppt presentation hundreds of charts linked same .xls file. want send presentation client , want him able access data. however, not want him open entire xls file when clicks on edit data.

so "convert" linked charts charts embedded excel contains info concerning specific chart. (i not sure if that's right way set it. sense distinction between embedded , linked not clear cutting anymore used in previous office versions)

i have found macro ppt 2003 copies old chart ,

set osh2 = osl.shapes.pastespecial(pppasteoleobject)(1)

but think longer work ( working ppt 2013).

any ideas on how highly appreciated. many thanks

if don't want give him access entire original workbook/worksheet, you'll need create multiple worksheets, each info want him able @ , either link or embed ppt file.

if create charts using old ms graph mini-app (still included, if optionally, office) can link info external excel file graph datasheet. i'm doing way give others access graph datasheet (ie info used graph) not linked source xl file.

i don't see way of doing new chart engine.

excel vba powerpoint