Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Using the Fields (Links and References:Link) in Word to Link to Specific Cells in Excel

Posted on 2003-11-06
4
154 Views
Last Modified: 2010-04-13
Hello:
Please help before I lose my mind. I write a Word document which requires 30 lines of data (rows in Excel) which I have to copy every day over to the Word document. Currenlty, I have to copy the cells, then paste them over, when I could set up the format and just change the data in teh Excel spreadsheet and just have the document update. I would get a life if I could do this.

I have 7 Columns with a header row and want to copy the header row and then each individual row with the header to Word, or set up a table in Word and insert the fields to reference the spreadsheet. I have tried to use the Link and references and cannot get it to work.

Here is what I use:
link ExcelSheet “C:\\Documents and Settings\\Desktop\\BDW-DP1106.XLS” A2 \

Each time I do this, I get Error! Not a valid link. I have searched and would appreciate a guru to show me the light. I would like to set a link in a table in each for for teh corresponding one in Excel.

Thanks, you guys/gals are great.

Omega
0
Comment
Question by:omegatrader
4 Comments
 
LVL 9

Accepted Solution

by:
svenkarlsen earned 250 total points
ID: 9698438
Hi Omega,
no worries ;-)

Open your Word document and go to the place where you want your Excel spreadsheet to appear.

Then, from the Word menu, click Insert > Object

Choose the page "Create from File"

Click "Browse..." and select your Excel spreadsheet

Check the "Link..." box

 --- and that it!

The spreadsheet will be displayed in Word with the lay-out that is has in Excel, - this means that any lay-out like lines, fonts, etc. should be done in Excel.

0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

NTFS file system has been developed by Microsoft that is widely used by Windows NT operating system and its advanced versions. It is the mostly used over FAT file system as it provides superior features like reliability, security, storage, efficienc…
Most MSPs worth their salt are already offering cybersecurity to their customers. But cybersecurity as a service is wide encompassing and can mean many things.  So where are MSPs falling in this spectrum?
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question