Linking from WORD to EXCEL

J

JTMBA33

I am trying to link a table in a word document to excel. Using the word
document as the masterfile/source document and the excel file as the target
document. This way when the data in the word document it updated, it
automatically updates the excel file.

I have discoverd using special paste and pasting the table from word to
excel , pastes the data as an object. I need the data to be pasted in the
cells so that I am able to filter and sort...

Is there a way to do this?
 
M

macropod

Hi JTMBA33,

A linked object must, by definition, replicate its source. Consequently, you can't have one sort order in Word and another in Excel.
A workaround would be to link each row from the Word table independently.
 
Top