Excel sorting prob with Word links

  • Thread starter Thread starter nellie
  • Start date Start date
N

nellie

1) thru the Edit\PasteSpecial\PasteLink function in Word,
I have linked what I highlight in Word (a reference point)
to a particular cell in Excel.
2) I plan to have several thousand such rows of data in
Excel, each one linked to a particular location in what
amounts to many different Word documents.
3) My intended goal is to be able to access a point in
Word, by double-clicking the appropriate cell in Excel.
So far, so good . . . it works.
MY QUESTION/PROBLEM IS THIS:
I desire to sort those eventual several thousand rows of
data in Excel, each one with a link to a Word location,
and I want the corresponding links to be sorted along with
all the other columns being sorted. The non-linked
columns will sort and the linked ones do not get sorted.
The linked data in the Excel cell looks like this:
Word.Document.8|'C:\MyDocuments\filename.doc'!'!OLE_LINK3'

Any help enabling me to sort the links would be greatly
appreciated. Nellie
 
FYI response, to anyone who noticed MY earlier question.
I resolved the problem by pasting the highlighted Word
entry as a hyperlink into an Excel cell, and could then
sort Excel. A simple solution; was a dumb question.
 
Back
Top