Results 1 to 5 of 5
  1. #1
    5 Star Lounger Ruff_Hi's Avatar
    Join Date
    Feb 2001
    Location
    New York, New York, USA
    Posts
    768
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Link to Word (Excel / Word XP)

    We have a number of reports that we write up on word, however, the calculations are done in excel. We used to manually transcribe the figures from excel to a work table but we now use linked pictures (set up the table in excel and link it into word). No more transcribing tables - <img src=/S/bananas.gif border=0 alt=bananas width=33 height=35>.

    However, there are times when we need to refer to an answer / calculation / number in the body of a paragraph ...

    Example: "blah blah blah ... We found that the total value of the widgets was $3,141,593. ... blah blah blah"

    What I would like to do is link the "$3,141,593" from an excel cell and leave the words in word. I know that I can link in an entire paragraph but I lose layout control with that solution.

    Any suggestions?
    (Location Australia, then UK, but now USA. Heart, outlook, attitude, etc always Australian)
    Quote: "All Happiness is the release of internal pressure"

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Link to Word (Excel / Word XP)

    You can paste a link to an individual cell too. If you paste as unformatted text, the link in Word will be part of a Word paragraph, an will take on the formatting used in Word.

  3. #3
    5 Star Lounger Ruff_Hi's Avatar
    Join Date
    Feb 2001
    Location
    New York, New York, USA
    Posts
    768
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Link to Word (Excel / Word XP)

    Wow - works like a dream. However, it looks exactly like a number in word. Is there a way of stopping someone from typing over it - or at least putting in a warning?
    (Location Australia, then UK, but now USA. Heart, outlook, attitude, etc always Australian)
    Quote: "All Happiness is the release of internal pressure"

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Link to Word (Excel / Word XP)

    If you insert a link to an Excel value as some kind of text (unformatted, formatted or HTML), it will be part of the Word paragraph, so the user can edit it. Unless the user completely deletes the field however, the value from Excel be restored the next time the field is updated, for example when the document is printed.

    A way to prevent the user from editing the value would be to put the field in a protected section (protect the document for forms), but unfortunately that locks down many other things in the document; this is often not desirable.

    If the users set Field Shading to Always in the View tab of Tools | Options..., they will at least see that the value is not ordinary text. On a network, the IT department could install a policy that enforces this setting.

  5. #5
    5 Star Lounger Ruff_Hi's Avatar
    Join Date
    Feb 2001
    Location
    New York, New York, USA
    Posts
    768
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Link to Word (Excel / Word XP)

    Great - I'll take the field shading option for 400. Thanks Hans - merry christmas.
    (Location Australia, then UK, but now USA. Heart, outlook, attitude, etc always Australian)
    Quote: "All Happiness is the release of internal pressure"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •