Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Problems: Linking & embedding Excel data and charts into Word
Does Microsoft or Office 2007 offer a better solution to live
linking/embedding data/charts from Excel into Word? I have the need to "live link" about 40 excel ranges into a Word document. In 2003, I tried this using the Copy_Paste Special_Link_Picture Windows Metafile. When I update the data in Excel (such as hiding or revealing a column or row), the linked pictures in Word move around on the page and sometimes don't update. A couple of years ago, Microsoft told me that this OLE technology cannot support the number of links into my Word report (After 2 gigs of ram, more video and printer memory) and offered no solution. I have since purchased a third party utility program as a solution, but it also has severe limitations and does not work on Office 2007. Does Microsoft or Office 2007 offer a better solution to live linking/embedding data/charts from Excel into Word? The need to live link tables and charts from Excel to Word just seems so common Thanks for your help. |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Problems: Linking & embedding Excel data and charts into Word
Hadn't really thought about that. I frequently hide/reveal columns and rows.
Do you think this format would be easier to control....keep pictures from flying around the page? Thx "CyberTaz" wrote: Why are you pasting as WMF instead of as MS Office Excel Chart Object? -- Regards |:) Bob Jones [MVP] Office:Mac "The Linker" The wrote in message ... Does Microsoft or Office 2007 offer a better solution to live linking/embedding data/charts from Excel into Word? I have the need to "live link" about 40 excel ranges into a Word document. In 2003, I tried this using the Copy_Paste Special_Link_Picture Windows Metafile. When I update the data in Excel (such as hiding or revealing a column or row), the linked pictures in Word move around on the page and sometimes don't update. A couple of years ago, Microsoft told me that this OLE technology cannot support the number of links into my Word report (After 2 gigs of ram, more video and printer memory) and offered no solution. I have since purchased a third party utility program as a solution, but it also has severe limitations and does not work on Office 2007. Does Microsoft or Office 2007 offer a better solution to live linking/embedding data/charts from Excel into Word? The need to live link tables and charts from Excel to Word just seems so common Thanks for your help. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking or embedding an Excel 2007 workbook in Word 2007 | Microsoft Word Help | |||
Linking Excel Data in a Word Document | Microsoft Word Help | |||
Problems connecting to Excel data source | Mailmerge | |||
Use an object linking to disply Excel worksheet data as a word tab | Tables | |||
Linking Excel data to tables in Word | Tables |