Quote:
Originally Posted by ptmuldoon
My word document is currently linking to 63 separate tables in Excel. All of those links are already in the document, and the user can simply press F9 or right click to update the table.
But there will be (and has happened already) times when the user mistakenly deletes the charts from table. And they do have the 'know how' on creating/adding the paste-link table back into the document.
|
Surely, then, the simplest method is to teach them how to do that the conventional way - select & copy the chart in Excel, then use Paste Special with the 'paste link' option in Word, without all the overheads you're building into the process. That also means the user can control where the chart gets pasted, which is much more difficult to achieve when you're using a macro tied to a content control.