pasting linked cell from Exc and maintaining formatting no matter


J

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?
 
Ad

Advertisements

D

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
 
J

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)?
 
D

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
 
J

JEB

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

Advertisements

D

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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top