linking excel 2000 to excel worksheet within Word 2000

J

Justin

I'm creating links for individual cells from excel to
excel worsheets within word so that my word documents are
automatically updated. I have been using copy/paste
special/paste link to make the link. A problem occurs
when I insert/delete rows from the excel document. For
instance, if i had cell A22 linked to the word document
and inserted a row 20, then the info from row A22 is now
in A23 but word is still linking to the actual cell A22.
I can fix this manually by deleting the absolute $'s from
the formula in the excel spreadsheets in the word doc's.
I'm trying to find a way to link it without having to
manually delete the dollar signs. Help!!!!!

Justin
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top