pasting linked cell from Exc and maintaining formatting no matter

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?

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" wrote in message
...
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?

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" wrote:

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" wrote in message
...
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?

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" wrote in message
...
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" wrote:

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" wrote in message
...
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?

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

"Doug Robbins - Word MVP" wrote:

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" wrote in message
...
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)?

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

"JEB" wrote in message
...
Yes, and it reformats the text and sometimes, all kinds of weird things
happen.

"Doug Robbins - Word MVP" wrote:

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" wrote in message
...
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)?