Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
The Linker The Linker is offline
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.word.docmanagement
The Linker[_2_] The Linker[_2_] is offline
external usenet poster
 
Posts: 1
Default 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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking or embedding an Excel 2007 workbook in Word 2007 MikeJacobs Microsoft Word Help 4 May 7th 07 06:46 PM
Linking Excel Data in a Word Document Denise C Microsoft Word Help 3 November 2nd 06 12:51 PM
Problems connecting to Excel data source maryj Mailmerge 1 March 31st 06 09:22 PM
Use an object linking to disply Excel worksheet data as a word tab mar Tables 1 March 22nd 06 10:30 PM
Linking Excel data to tables in Word KSit Tables 3 November 26th 04 10:36 PM


All times are GMT +1. The time now is 06:22 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"