Tags: chart, document, dynamic, embedded, excel, excelsheet, microsoft, msdn, named, object, ranges, sheet, software, syntax, word, workbook
embedded Excel sheet in word document - how to use named ranges
How can I use named dynamic ranges in a chart object in an embedded Excel
sheet in a Word document? The normal syntax uses the workbook name, but I
don;t know what the workbook name is for an embedded sheet. Thanks in
advance to anyone who can help sort this out.
Leave a comment...
- 1 Comments
- Do you mean that you have an embedded XL wkbk in a Word doc & you want to
plot the data in a separate XL wkbk (.xls) file linked to the embedded
If so you don't need named ranges for one approach, although I can't attest
to its endurance:
Double-click the object in the doc, then select & copy the range of data to
In the destination wkbk select a starting cell then go to Edit>Paste
Special, click the Paste Link: option & choose Excel 8.0 Format.
Another possibility is that you want to have the data entered in the doc &
the chart based on it displayed as the embedded XL object. If that's it,
copy the data in the embedded object, set the chart sheet to display, then
go back into the doc & use Edit>Paste Special - Paste Link: & select either
Formatted or Unformatted Text. Either will give you a Word table or tabbed
text linked to the objects data range. When you edit the data in the object
the content of the table will update.
Either of the above can be rather fragile, so if I'm at all on track with
either guess (especially the latter), why not just use Word's
Insert>Picture>Chart feature to create the chart in the first place & invoke
the option to display the Data Table?
If this isn't what you have in mind I don't know what to suggest but perhaps
someone else will.
"Wazooli" <Wazooli.ms-word.todaysummary.com.discussions.microsoft.com> wrote in message
> How can I use named dynamic ranges in a chart object in an embedded Excel
> sheet in a Word document? The normal syntax uses the workbook name, but I
> don;t know what the workbook name is for an embedded sheet. Thanks in
> advance to anyone who can help sort this out.#1; Tue, 03 Jun 2008 23:07:00 GMT