File Not Found dialogue

[Leslie Coover]

Excel 2000



Do you know why the annoying "File Not Found" dialog box

shows up?



This happens when I move a few of the work sheets out

of my main spreadsheet, which contains about 25 worksheets.



In other words, I create a smaller file by exporting just 3 worksheets

that are part of a large file that contains about 25 worksheets.



If I click the "X" (File Close) button several times, the

annoying dialog boxes finally go away, only to re-appear the

next time I open the small file.



The worksheets that I want to use to create the small file were

originally produced by making copies of other worksheets in my

large file-would this cause the problem?



I also have this same problem in a class I am taking. OM-Explorer is a

software package that goes with the course. Sometimes I want

to export just 3 worksheets (found in the OM-Explorer file folder)

into my large spreadsheet, but I have to re-create the worksheets

by hand instead of just importing them, or I get the annoying

File Not Found dialogue box.



Any suggestions welcomed.

 

[Pete_UK]

I suggest you probably have links in the (smaller) file back to the
original file, and if you have moved the original file to a different
folder then Excel will not know about this, and so can't find the file
the links refer to. Named ranges can also give rise to the same effect
and are not so easy to spot.

Hope this helps.

Pete