Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Nov 2001
    Posts
    40
    Thanks
    0
    Thanked 0 Times in 0 Posts

    workbooks with automatic links (excel 97 sr 2)

    I have inherited files from someone who at one point had excel spreadsheets that linked to other spreadsheets.

    The current versions of these spreadsheets do not link to other sheets, but some property of the file still makes Excel think that it is.

    When I open the spreadsheet I get the message:

    The workbook you opened contains automatic links to information in another workbook.
    Do you want to update this workbook with changes made to the other workbook?
    To update all linked information click yes
    To keep existing information click no

    There are no links in the spreadsheet I am opening.

    What property of the file can I change so that Excel no longer sees this file as linking to another file?

    thanks

  2. #2
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: workbooks with automatic links (excel 97 sr 2)

    <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Cat=&Board=xl&Number=30606&page=&v iew=&sb=&o=&vc=1#Post30606>This post</A> adds just a little to Wassim's post.
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  3. #3
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: workbooks with automatic links (excel 97 sr 2)

    iruser2

    Links have always been a trouble. You have a couple of choices:
    1) Get Bill Manville's FindLink Add-In at http:// www.bmsltd.ie/MVP/Default.htm
    2) Get Microsoft Link Add-In from http:// support.microsoft.com/default.aspx?scid=kb;EN-US;Q188449
    3) Search for the links manually and delete them.

    Wassim

    Edited Mar 13th 2004 to update link
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

Posting Permissions

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