Results 1 to 7 of 7
  1. #1
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Crazy Links (Excel 2002)

    Hi,
    I recieved two files via email. The one file has the data and charts. The second file has linked copies of the charts pasted as an object. The problem is that I cannot change the link of the pasted obj to read from the first file. ie, the charts are not updating automatically when I change values in the source file. I have gone to EDIT | LINKS, and chosen Change Source, but it gives a smaller dialog and when I type the new path in there it throws me an error message and it does not change the link!!!! I even tried to delete the object, copy the original chart and paste with a link, but Paste Special is then greyed out!!! What can I do to correct this! HELP!

    Below is an image of the pasted chart object. The link you see in the formula bar is the old link to the senders source file. I saved the source file I recieved to C:Test, and I cannot seem to change the object to route to this location!!!
    Regards,
    Rudi

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

    Re: Crazy Links (Excel 2002)

    You're not trying to open the files from within the e-mail, are you?

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Crazy Links (Excel 2002)

    No, I saved both to C: ?

    I've never encountered such hassles with a linked object before. I can't understand why I cannot change the path!
    Regards,
    Rudi

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

    Re: Crazy Links (Excel 2002)

    The link is not an ordinary link; from the formula in the formula bar it seems that the chart has been inserted as an object.

    You might try the free Navigator Utilities - they contain a more powerful "Edit Links" feature.

  5. #5
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Crazy Links (Excel 2002)

    Thnx. I'll look into these utilities the moment I get a chance to! <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

    Another question.
    How can a chart be copied to another workbook with a link? I've tried copy, but paste special is not available...I've tried copy picture, but paste link is not active???
    Any ideas
    Regards,
    Rudi

  6. #6
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Crazy Links (Excel 2002)

    The way I typically use:
    Have both workbooks open.
    In the source workbook, create a copy of the chart in the source workbook (copy the sheet or just hold ctrl-while dragging the chart object)
    CUT the copy you just created in the source
    Paste it to the destination workbook.

    This essentially MOVES the chart and the chart is copied and the "source data" of the chart is a direct link to the source workbook.

    Steve

  7. #7
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Crazy Links (Excel 2002)

    Many many thanks Steve. This does recreate the link to the source. Thanx for the response!
    Regards,
    Rudi

Posting Permissions

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