Results 1 to 6 of 6
  1. #1
    Star Lounger
    Join Date
    Dec 2007
    Posts
    98
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Paste/Link (2003)

    My goal is to paste a chart/table from Excel to Word and the data would automatically update when new data are entered into Excel. If I copied and pasted the table/chart with OUT being linked to Excel then it fits nicely on 1 page in Word but If I pasted specia/link then it takes 2 or 3 pages. Is there a better way? Thank you.

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

    Re: Paste/Link (2003)

    Select Edit | Paste Special... in Word.
    Tick the Paste Link check box.
    Select Microsoft Excel Worksheet Object in the list of available formats.
    When you click OK, the pasted object should fit within one page.

  3. #3
    Star Lounger
    Join Date
    Dec 2007
    Posts
    98
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Paste/Link (2003)

    Hello Hans-

    I tried your method (Edit-Paste special-Paste link(MS Excel Worksheet object)-OK) but it does not work instead it cuts my table in half. The table from Excel was scaled down to 66% when I copied and pasted. Does this make any different?

    Thank you for your assistance.

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

    Re: Paste/Link (2003)

    Does the pasted object really contain less than what you copied, or is part of it off the page? What happens if you resize the pasted object?

  5. #5
    Star Lounger
    Join Date
    Dec 2007
    Posts
    98
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Paste/Link (2003)

    Thank you for your suggestion. I had to read on resize a pasted object and it works!!! Yeah!!Danke!!!!

    p.s. Do you sleep? I feel like you're available 24/7. Thank you<img src=/S/smile.gif border=0 alt=smile width=15 height=15> <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

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

    Re: Paste/Link (2003)

    Er, yes, I do sleep... <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    Glad the problem is solved!

Posting Permissions

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