Converting linked objects to embedded in Word 2010

[wduvall]

Hello,

I would like to make a template excel and word files for a recurring report I have to produce. Ideally, I would like to have all of the charts in Word be linked (so the automatically update when I change the Excel file). Once I'm ready to submit the report, though, I would like it to stand alone and contain all of the data without relying on the excel file (i.e. convert all of the objects from linked to embedded).

Any idea how to do this?



Thanks!