ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Opening Excel document from Explorer (https://www.excelbanter.com/excel-discussion-misc-queries/212897-opening-excel-document-explorer.html)

Dale

Opening Excel document from Explorer
 
I am having problems opening Excel 2007 documents from Explorer. I have read
through the other threads and tried Excel Options/Advanced/General/Ignore
other applications. It did not work in my case.

I also tried run / Excel /unregister then /register. As well, this did not
solve the issue.

What I found was after double clicking the icon in explorer, Excel opens but
is blank. Then if I single click on the office button, the file opens. The
file also opens if I double click on the icon in explorer a second time
(after excel is already open).

Of course, I can also open a file by first opening Excel and going through
the Office/Open menu.
--
Dale

Jim Rech

Opening Excel document from Explorer
 
Your only sure option is to not use DDE to open Excel workbooks. This has
the side effect of opening each double-clicked workbook in a new Excel
instance. If you can live with this:

Go to Control Panel, Folder Options, File Types, scroll down to and select
XLS, click Advanced, select Open entry, click the edit Button.
Now uncheck "Use DDE" and then put your cursor in the Application box, arrow
all the way to the right and put in <space%1 after the /e that is likely
there. Then OK you way out.

You'll have to repeat this for other file extensions like XLSX.

--
Jim
"Dale" wrote in message
...
|I am having problems opening Excel 2007 documents from Explorer. I have
read
| through the other threads and tried Excel Options/Advanced/General/Ignore
| other applications. It did not work in my case.
|
| I also tried run / Excel /unregister then /register. As well, this did
not
| solve the issue.
|
| What I found was after double clicking the icon in explorer, Excel opens
but
| is blank. Then if I single click on the office button, the file opens.
The
| file also opens if I double click on the icon in explorer a second time
| (after excel is already open).
|
| Of course, I can also open a file by first opening Excel and going through
| the Office/Open menu.
| --
| Dale



All times are GMT +1. The time now is 11:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com