Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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. |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
embedded Excel sheet in word document - how to use named ranges
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 EditPaste 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 EditPaste 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 InsertPictureChart 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" 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. |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
embedded Excel sheet in word document - how to use named range
Actually, I am using a unlinked embedded excel sheet. I don't want to link
to an external workbook because I want the word document to stand on its own. "CyberTaz" wrote: 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 EditPaste 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 EditPaste 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 InsertPictureChart 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" 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. |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
embedded Excel sheet in word document - how to use named ranges
Hi ?B?V2F6b29saQ==?=,
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. There is no reliable way to link the data in one embedded Excel object to a different embedded Excel object. Depending on the version of Word, you can sometimes get a link for the duration of the time the document is open. But as soon as it's closed, the link information is lost. If you can't use an external file, then you're going to need a programmed solution (non-trivial) that updates the table in the object showing the chart from the object with the worksheet. Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word 97 in Windows XP to maintain formatting | Microsoft Word Help | |||
Index Match in Word Table, or Embedded Excel? | Tables | |||
I am having difficulty with deleting headers and footers | New Users | |||
Change paper size; Word changes to invalid margins | New Users | |||
Word & WordPerfect | Microsoft Word Help |