Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Jun 2001
    Posts
    56
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Insert Object (Excel97)

    In Excel97 I selected Insert, Object, Create From File, selected an Excel file & checked the Link to File box. When highlighted, the resulting object displays the file path & name of the source file in the formula bar. Logically enough, when a value in the source file is changed, so is data in the destination file. However, when the source file is deleted, there are no error messages in the destination file, as I expected, nor did the object disappear. Instead the most recent information the source file contained is displayed in the destination file, despite the fact that the source doesn't exists anymore. Is that supposed to happen?

    Tanya

  2. #2
    New Lounger
    Join Date
    Sep 2002
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Insert Object (Excel97)

    <hr>Is that supposed to happen?<hr>
    Yep.

    A linked object is merely a picture of that object. The only link aspect is in refreshing or updating it. If there's no way to update it (source file deleted) if still carries the last picture of the object. To force it to update, in such a case, would be to get an error message stating it could not find the source file. But that does not mean the destination program will delete the picture of it.

    IF... that were the case where all linked objects get deleted from the destination file if the source file could not be located, we'd be in a real world of hurt. Many times it happens where a link is broken due to a file being moved or folders being restructured. We still need a picture of the object so we can re-establish the link.

    Gregg

  3. #3
    Star Lounger
    Join Date
    Jun 2001
    Posts
    56
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Insert Object (Excel97)

    GreggBeck,
    Hmmmm, that's curious.Thanks for your response.

    Tanya

Posting Permissions

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