Excel/Windows cannot find the file I clicked on to open it

R

Red Kite

Windows XP Home, Office 2003
When I click on an .XLS file, Excel 2003 opens but Windows (or Excel?) says
the file cannot be found!! The path it quotes in the error message is totally
correct. If I now navigate to the file in the Open dialog it opens (after
virus check). This did not happen with Office XP (2002). Any ideas on the
cause of this bizarre behaviour?
 
G

Gary''s Student

Try making sure that ignore other application is clear (NOT checked ) in

Tools > Options > General
 
R

Red Kite

I looked there and that IS not checked.
I played with the 'Service options' there and unchecked the online access to
Office Online as being unwanted for me, and Excel opens a clicked file
correctly. However I set those boxes back on and it still works OK.
Confusing!
I'll see what happens after the next reboot.
 
C

calico7

Where did you make this change? I have Office 2007 and can't seem to find
the "ignore other application" option.
 
D

Dave Peterson

It's under that Office button.
Click the Options(?) at the bottom.

(I don't have xl2007 running right now)
 
R

Red Kite

After Hibernation and Resume the original problem returned; click on XLS file
gets cannot find. But now, after opening Excel and forcing it to the file,
which opens correctly, Excel WILL now find other files when clicked, even in
differing places, even when Excel is not running.
This gets more confusing. It does not happen with Word2003 or Excel2002.
 
D

Dave Peterson

Just a guess...

If the file is on a network drive, maybe the hybernation caused the network
drive to be disconnected????

Can you either remap that drive or do something else that wakes up that
connection?

===
If this guess is correct, you may want to contact your IT group. IIRC, there is
a registry setting that allows you to set disconnect time to never. I couldn't
find it in my old emails, but I'd bet you could find it via google (that's how I
found it a year ago).
 
Top