Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
ConfusedNHouston
 
Posts: n/a
Default Excel Files Won't Open From Shortcut

The title's misleading but I couldn't find a way to express it succinctly.
If I have 2 Excel windows open, with one or more workbooks within each
window, and I click on an Excel file-name in Windows Explorer or on a
shortcut to an Excel file-name, nothing happens. If I close both Excel
windows and try it, the file will open. Or if I go to Files, Open, and
Browse to the file name it will open. This is both new and a pain in the
rear. As recently as 3 months ago I could open six or eight Excel files at
the blink of an eye, from Windows Explorer or from shortcuts. What changed?
How can I change it back to the way it was?

Thanks "ConfusdNHouston"
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
try: 'Tools - Options - General' and uncheck 'Ignore other applications'

--
Regards
Frank Kabel
Frankfurt, Germany
"ConfusedNHouston" schrieb im
Newsbeitrag ...
The title's misleading but I couldn't find a way to express it succinctly.
If I have 2 Excel windows open, with one or more workbooks within each
window, and I click on an Excel file-name in Windows Explorer or on a
shortcut to an Excel file-name, nothing happens. If I close both Excel
windows and try it, the file will open. Or if I go to Files, Open, and
Browse to the file name it will open. This is both new and a pain in the
rear. As recently as 3 months ago I could open six or eight Excel files
at
the blink of an eye, from Windows Explorer or from shortcuts. What
changed?
How can I change it back to the way it was?

Thanks "ConfusdNHouston"



  #3   Report Post  
ConfusedNHouston
 
Posts: n/a
Default

Frank I appreciate the suggestion, but the Ignore other applications is not
checked. Anything else it might be?

"Frank Kabel" wrote:

Hi
try: 'Tools - Options - General' and uncheck 'Ignore other applications'

--
Regards
Frank Kabel
Frankfurt, Germany
"ConfusedNHouston" schrieb im
Newsbeitrag ...
The title's misleading but I couldn't find a way to express it succinctly.
If I have 2 Excel windows open, with one or more workbooks within each
window, and I click on an Excel file-name in Windows Explorer or on a
shortcut to an Excel file-name, nothing happens. If I close both Excel
windows and try it, the file will open. Or if I go to Files, Open, and
Browse to the file name it will open. This is both new and a pain in the
rear. As recently as 3 months ago I could open six or eight Excel files
at
the blink of an eye, from Windows Explorer or from shortcuts. What
changed?
How can I change it back to the way it was?

Thanks "ConfusdNHouston"




  #4   Report Post  
Gord Dibben
 
Posts: n/a
Default

The standard fixes for this problem.......

ToolsOptionsGeneral uncheck "Ignore other Applications"
Exit Excel and try again

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

Close Excel first and
On the Windows Taskbar

1) StartRun "excel.exe /unregserver"(no quotes)OK.
2) StartRun "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 StartRun "C:\yourpath\excel.exe /regserver"(no quotes)OK.

One more thing to try if any of the above brings no joy.........

Go to StartSettingsFolderOptionsFile Types. Scroll down to MS Excel
Worksheet. Then if running Win98 OS Edit select "Open" and Edit.

If using WinXP OS you would scroll down to .XLS then "Advanced"OpenEdit.

In Command line the path should be similar to this....

"C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE\EXCEL.EXE" /e (delete the <sp/e if
you want Book1 to open.

You must have the double quotes.

Below have "use DDE" checked and this in the DDE message box....[open("%1")]

Application should read "Excel"(no quotes)


Gord Dibben Excel MVP

On Thu, 30 Dec 2004 13:57:02 -0800, "ConfusedNHouston"
wrote:

Frank I appreciate the suggestion, but the Ignore other applications is not
checked. Anything else it might be?

"Frank Kabel" wrote:

Hi
try: 'Tools - Options - General' and uncheck 'Ignore other applications'

--
Regards
Frank Kabel
Frankfurt, Germany
"ConfusedNHouston" schrieb im
Newsbeitrag ...
The title's misleading but I couldn't find a way to express it succinctly.
If I have 2 Excel windows open, with one or more workbooks within each
window, and I click on an Excel file-name in Windows Explorer or on a
shortcut to an Excel file-name, nothing happens. If I close both Excel
windows and try it, the file will open. Or if I go to Files, Open, and
Browse to the file name it will open. This is both new and a pain in the
rear. As recently as 3 months ago I could open six or eight Excel files
at
the blink of an eye, from Windows Explorer or from shortcuts. What
changed?
How can I change it back to the way it was?

Thanks "ConfusdNHouston"





  #5   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
try to re-register Excel

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


--
Regards
Frank Kabel
Frankfurt, Germany
"ConfusedNHouston" schrieb im
Newsbeitrag ...
Frank I appreciate the suggestion, but the Ignore other applications is
not
checked. Anything else it might be?

"Frank Kabel" wrote:

Hi
try: 'Tools - Options - General' and uncheck 'Ignore other applications'

--
Regards
Frank Kabel
Frankfurt, Germany
"ConfusedNHouston" schrieb
im
Newsbeitrag ...
The title's misleading but I couldn't find a way to express it
succinctly.
If I have 2 Excel windows open, with one or more workbooks within each
window, and I click on an Excel file-name in Windows Explorer or on a
shortcut to an Excel file-name, nothing happens. If I close both Excel
windows and try it, the file will open. Or if I go to Files, Open, and
Browse to the file name it will open. This is both new and a pain in
the
rear. As recently as 3 months ago I could open six or eight Excel
files
at
the blink of an eye, from Windows Explorer or from shortcuts. What
changed?
How can I change it back to the way it was?

Thanks "ConfusdNHouston"








  #6   Report Post  
ConfusedNHouston
 
Posts: n/a
Default

My thanks to both of you for taking the time to respond. I did the excel.exe
/ thing and it worked just fine. Thanks again.

"Frank Kabel" wrote:

Hi
try to re-register Excel

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


--
Regards
Frank Kabel
Frankfurt, Germany
"ConfusedNHouston" schrieb im
Newsbeitrag ...
Frank I appreciate the suggestion, but the Ignore other applications is
not
checked. Anything else it might be?

"Frank Kabel" wrote:

Hi
try: 'Tools - Options - General' and uncheck 'Ignore other applications'

--
Regards
Frank Kabel
Frankfurt, Germany
"ConfusedNHouston" schrieb
im
Newsbeitrag ...
The title's misleading but I couldn't find a way to express it
succinctly.
If I have 2 Excel windows open, with one or more workbooks within each
window, and I click on an Excel file-name in Windows Explorer or on a
shortcut to an Excel file-name, nothing happens. If I close both Excel
windows and try it, the file will open. Or if I go to Files, Open, and
Browse to the file name it will open. This is both new and a pain in
the
rear. As recently as 3 months ago I could open six or eight Excel
files
at
the blink of an eye, from Windows Explorer or from shortcuts. What
changed?
How can I change it back to the way it was?

Thanks "ConfusdNHouston"






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problems opening Excel files using DFS links Byron Excel Discussion (Misc queries) 2 January 1st 05 11:31 PM
Can't open many XLS files at once [email protected] Excel Discussion (Misc queries) 10 December 19th 04 07:52 PM
How to open 123 files with excel Jeff B 813 Excel Discussion (Misc queries) 3 December 8th 04 09:11 PM
Cannot open a file that Excel says is open Plodhia Excel Discussion (Misc queries) 2 December 7th 04 01:43 AM
How do I open Excel 4.0 files in Office 2000? Tom_Hunn Excel Discussion (Misc queries) 1 November 29th 04 11:49 AM


All times are GMT +1. The time now is 10:15 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"