Cannot double-click to open file

[Chris M.]

I've written some code to pull data from Access and sort
it into something presentable. The problem is that once
the spreadsheet has been created, I cannot open it by
double-clicking on it. All that appears is the excel
header, toolbar, and border, but where the spreadsheet
should be, I just see my desktop. I can open it if I open
excel first then go to File -> Open. This problem is
duplicatable on other people's machines too. Any
suggestions on hwo to fix this?

 

[Bob Umlas]

Check tools/options/General -- see if you have "Ignore other applications"
checked. If so, uncheck it, exit excel & try again.

Bob Umlas
Excel MVP

 

[Chris M.]

I'm afraid that that does not fix the issue. I had
checked it initially in an attempt to fix the issue,
unchecked it and the issue continues.

 

[Ron de Bruin]

Try this

On the Windows Taskbar
Close Excel
Start>Run "excel.exe /regserver"(no quotes)>OK.
See the space between exe and /regserver

You might have to designate a full path to excel.exe.
In that case Start>Run "C:\yourpath\excel.exe /regserver"(no quotes)>OK.

 

[Chris M.]

I'm afraid that didn't work either. I've used that to fix
problems previously, but hadn't tried it on this one. I
can't find a thing about this on Microsoft's knowledge
base. I've tried it now on over 10 systems here at work
and they all do it. If I recreate the spreadsheet from
scratch, import the code and run it, the problem recurrs.
Any other suggestions? Thanks for the previous help.

-----Original Message-----
Try this

On the Windows Taskbar
Close Excel
Start>Run "excel.exe /regserver"(no quotes)>OK.
See the space between exe and /regserver

You might have to designate a full path to excel.exe.
In that case

Start>Run "C:\yourpath\excel.exe /regserver"(no quotes)>OK.

 

[Chris M.]

Also, strangely, if I log off of the network, and then log
back in, I can open the file without a problem. If I
execute the code again, I cannot open that spreadsheet, or
any other without this problem until I log out and back
into the network.

-----Original Message-----
Try this

On the Windows Taskbar
Close Excel
Start>Run "excel.exe /regserver"(no quotes)>OK.
See the space between exe and /regserver

You might have to designate a full path to excel.exe.
In that case

Start>Run "C:\yourpath\excel.exe /regserver"(no quotes)>OK.

 

[Ken Macksey]

Hi

I had a similar problem and tried all the fixes suggested above. None
worked.
Ron's solution usually works, but occasionally it fails for some reason.
Un-registering excel and then re-registering it fixed my problem.

On the Windows Taskbar
Close Excel
Start>Run "excel.exe /unregserver"(no quotes)>OK.
See the space between exe and /regserver

then

On the Windows Taskbar
Close Excel
Start>Run "excel.exe /regserver"(no quotes)>OK.
See the space between exe and /regserver


HTH

Ken