Solved

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

Posted on 2003-11-06
4
150 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

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

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…
What is Backup? Backup software creates one or more copies of the data on your digital devices in case your original data is lost or damaged. Different backup solutions protect different kinds of data and different combinations of devices. For e…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

747 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now