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

On Microsoft » Microsoft Word

2,226 words with 1 Comments; publish: Tue, 03 Jun 2008 23:06:00 GMT; (30062.50, « »)

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.

All Comments

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

      object?

      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

      be plotted.

      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.

      HTH |:>)

      Bob Jones

      [MVP] Office:Mac

      "Wazooli" <Wazooli.ms-word.todaysummary.com.discussions.microsoft.com> wrote in message

      news:B9E8AAD8-A51C-46A5-B228-E07F1F879465.ms-word.todaysummary.com.microsoft.com...

      > 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