Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    May 2004
    Location
    Toronto, Ontario, Canada
    Posts
    425
    Thanks
    5
    Thanked 0 Times in 0 Posts

    link or copy? (Excel 2003)

    Hi all,

    I have a workbook on a fileserver and would like to know, is it possible to link an entire sheet from a workbook? I am trying to include 3 worksheets from another workbook, so that I can combine them into a webpage.

    Is copy and paste my only real option here?

    Or can I link all the cells in a worksheet to basically be a copy of the data source worksheet?

    Thanks,
    Darryl.

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

    Re: link or copy? (Excel 2003)

    You can only link cells, not entire worksheets. You can link all cells in the used area of a worksheet, though:
    - Select the used area of the source worksheet.
    - Copy to the clipboard.
    - Select the upper left corner of the target area in the destination worksheet.
    - Select Edit | Paste Special...
    - Click the Paste Link button.

  3. #3
    4 Star Lounger
    Join Date
    May 2004
    Location
    Toronto, Ontario, Canada
    Posts
    425
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Re: link or copy? (Excel 2003)

    Thank you Hans.

Posting Permissions

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