[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

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

Posted on 2003-11-06
4
Medium Priority
?
158 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
[X]
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
4 Comments
 
LVL 9

Accepted Solution

by:
svenkarlsen earned 1000 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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

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…
With so many activities to perform, Exchange administrators are always busy in organizations. If everything, including Exchange Servers, Outlook clients, and Office 365 accounts work without any issues, they can sit and relax. But unfortunately, it…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

656 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