formatting of linked Excel text

[Guest]

Hi All

I have a word document containing a link (unformatted text) from a cell in
an Excel file. In Word, I have formatted this text to be a specific way.
The length of text in the cell changes when I update the data. When there is
a large amount of text in the cell, only the first few words are formatted in
the proper way.

I hope this makes sense. It is a problem I have been working with for a
while. Any help is appreciated.

Thanks

Nick

 

[Graham Mayor]

Right click the link field. Toggle the data and you get a display something
like:

{ LINK Excel.Sheet.8 "D:\\My Documents\\Test\\Filename.xls" "Sheet1!R3C1" \a
\f 4 \h}

Add a charformat switch

{ LINK Excel.Sheet.8 "D:\\My Documents\\Test\\Phones.xls" "Sheet1!R3C1" \a
\f 4 \h \*charformat}

then F9 to update and toggle the field display back again.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>