Linked Charts in PPT 2007

[Mike CR]

Hi - here is what I want to do:

For each customer I do an assessment with, I produce an Excel Workbook from
a Master template if you will (the original Excel workbook, renamed and
stored in a new folder). Each customer Workbook will have different numbers,
but the format remains the same otherwise (cell references, links, and charts
& graphs)

For each customer, I produce a summary PPT deck of my findings. Within this
deck I have traditionally Copied / Pasted graphs etc., linking them to the
specific Workbook I am using. However, as I do more of these assessments
this is very time consuming.

What I want to do is this: have my master Excel Workbook, a master PPT2007
Deck, and when I copy the masters to specific customer folders update the
cell, chart and graph links as well, so, as I populate the new Excel
Workbook, the PPT deck is also updated.

Any thoughts?

Thanks in advance.

M

 

[Echo S]

I don't know if it will work or not, but can you just change the link to the
newly renamed workbook in PPT's Edit Links dialog?

 

[Mike CR]

Thanks Steve. I came across this macro in my research (you had provided to
another person some time back) and tried it. While it did update linked
cells, charts themselves were not updated. The links within the workbook
were updated to reflect the new path, but the references to the arrays from
which the charts are comprised did not work. I will review again though to
make sure there were no typos etc. in the macro.