pasting linked cell from Exc and maintaining formatting no matter

[JEB]

I am linking a data cell from Excel into Word.

I am using the paste special, paste link: unformatted text

I make adjustments to the font and font size in Word. I goto Excel, and I
modify the text in the cell and go back to Word and it changes.

How can I get the formatting to stay the same, no matter what?

 

[Doug Robbins - Word MVP]

In the WOrd document, press Alt+F9 to display the field codes and add the \*
charformat switch inside the closing }, replacing \* mergeformat if it is
there. Now apply the desired formatting to the L of Link then press Alt+F9
again to toggle off the display of the field codes.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

 

[JEB]

That worked when the information was modified or completely changed within
the same file, but what about the cases where you change the link to a
different file (but the same corresponding cell)?

 

[Doug Robbins - Word MVP]

Have you tried pressing F9 to update the field?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

 

[JEB]

Yes, and it reformats the text and sometimes, all kinds of weird things happen.

 

[Doug Robbins - Word MVP]

Even with the \* charformat switch?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com