find files

[pinkpig]

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.

 

[s-o-s]

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.

 

[klb]

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