Excel (Source Doc) to Word (Linked file)

  • Thread starter Thread starter JG
  • Start date Start date
J

JG

I have given every cell in Excel a range name. When
these are paste linked as a rich text format item, the
cell reference (e.g., R10 C 3) shows up as the link in
the Word document rather than the range name.

How do I solve this problem?
 
Hi Jg,
I have given every cell in Excel a range name. When
these are paste linked as a rich text format item, the
cell reference (e.g., R10 C 3) shows up as the link in
the Word document rather than the range name.

How do I solve this problem?
Click to expand...
You can't force Excel to use the range name via copy/paste.
You'd need to edit the LINK field code after it's been
generated (Alt+F9 to toggle the field codes).

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Sep 30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail
:-)
 
Back
Top