Solved

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

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

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…
Note: This is the second blog post in a series on email clearinghouses (https://www.xmatters.com/alert-management/blog-email-has-failed-us?utm_campaign=70138000000ydLoAAI&utm_source=exex&utm_medium=article&utm_content=blog-post).   Every month t…
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

920 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

16 Experts available now in Live!

Get 1:1 Help Now