Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: find files

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Everytime I open a specific excel file it automatically searches for files that I don't need. I'm not sure whether these files were ever used in conjunction with the file I am working on but the files it is looking for are not on my system and I don't want excel to look for them because it throws up a file not found dialog box each time.

    How can I get it to stop?

    Thanks.

  2. #2
    Board Regular s-o-s's Avatar
    Join Date
    Apr 2002
    Location
    Kissimmee, Florida
    Posts
    384
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    There are several places for Hidden Links.

    Save your work and use a temporary version as you can change data by changing links.

    The easiest to find are using

    Edit Links

    What you do then depends on your data, you have a number of options:

    1) Change the links to a different file (Change Source)


    2) Find the location of linked cells and change them to values.


    Select every tab in a workbook (Check incase you have any hidden sheets - Format Sheet unhide)

    Ctrl F (Find) then copy and paste values. Make sure that you take off the grouped sheets before copy/pasting. If the values are not needed you can just delete the cells.



    The Next place for hiding hidden links is in named ranges:

    Insert Name Define.

    In the dialog box click the first spreadsheet name and look at the reference (Bottom line of dialog box). If the link points to a non existent file delete the link.

    There could be something in an auto-open macro, in the VBE check the This workbook module to see if this is the case.



    Hope This Helps.
    Sean.
    Digest of Homes

    WinXP, XL XP

  3. #3
    Board Regular
    Join Date
    Apr 2002
    Location
    Minnesota
    Posts
    821
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Somewhere in your file you have a link to these files. It may be in a cell formula or it may be in a named range.

    You need to do a search for the file name and delete it when you find it.

    If these links are preventing the file from opening, you should uncheck the "update remote references" box under Menu Tools Options Calculation before opening the file

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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