This is an interesting puzzle and there must be a solution to achieve the aims. Perhaps embedding the changeable data as xml and then have a macro create the set of output tables and charts.

If documents were created in pairs you shouldn't need to re-paste the content, just update the path to the Excel file would be the simpler option.

Can you post a sample document we could do some experimenting on?

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia