File open from Windows Explorer fails after Get External Data

[Fred Newton]

Using Excel 97, is anyone aware of a problem where, after having "got
external data" from a SQL database into a spreadsheet, an Excel file
will not open from Windows Explorer. I receive no error messages, the
open simply does nothing. The only way of opening files is by using
the File Open within Excel or closing Excel and re opening all files
without "getting external data" at any time.

Many thanks
Fred Newton
Zurich Financial Services

 

[Frank Kabel]

Hi
try the following:
goto 'Tools-Options-General " and uncheck "Ignore other Applications"
Exit Excel and try again

If this doesn't work try to re-register Excel

1. Close Excel first and
2. On the Windows Taskbar
2.1 Start>Run "excel.exe /unregserver"(no quotes)>OK.
2.2 Start>Run "excel.exe /regserver"(no quotes)>OK.