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

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
omegatraderAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

svenkarlsenCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows 2000

From novice to tech pro — start learning today.