I have a large excel workbook with dozens of charts. What I now intend to do is copy all these charts and paste them to Word document. In the mean time, I want the source data embeded in Word doc so that others can access the source data.
The problem is that every embeded chart in the doc keeps one copy of source data so there are dozens of copies of the same Excel source data in the doc, which makes the doc file extremely large and seriously slows down the loading.
Is it possible to keep only one single copy of the source while users can access the source from any of the charts in the doc file? In other words, I want all charts in the doc are linked to the same Excel file which is embeded in the doc.
The problem is that every embeded chart in the doc keeps one copy of source data so there are dozens of copies of the same Excel source data in the doc, which makes the doc file extremely large and seriously slows down the loading.
Is it possible to keep only one single copy of the source while users can access the source from any of the charts in the doc file? In other words, I want all charts in the doc are linked to the same Excel file which is embeded in the doc.