Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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? |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
pasting linked cell from Exc and maintaining formatting no matter
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? |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
pasting linked cell from Exc and maintaining formatting no matter
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? |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
pasting linked cell from Exc and maintaining formatting no mat
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? |
#5
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
pasting linked cell from Exc and maintaining formatting no mat
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? |
#6
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
pasting linked cell from Exc and maintaining formatting no mat
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? |
#7
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
pasting linked cell from Exc and maintaining formatting no mat
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? |
#8
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
pasting linked cell from Exc and maintaining formatting no mat
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)? |
#9
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
pasting linked cell from Exc and maintaining formatting no mat
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)? |
#10
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
pasting linked cell from Exc and maintaining formatting no mat
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)? |
#11
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
pasting linked cell from Exc and maintaining formatting no mat
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)? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pasting linked excel cell and maintaining formatting no matter wha | Microsoft Word Help | |||
Maintaining Linked pictures etc with zip Archive | Microsoft Word Help | |||
Pasting linked chart into table cell | Tables | |||
Maintaining Formatting When Copy and Pasting | Microsoft Word Help | |||
Maintaining the format of linked tables. | Tables |