Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Stuart
 
Posts: n/a
Default Can't open spreadsheet via shortcut

Example: Suppose I have a shortcut that points to C:\Program Files\Test
Folder\abc.xls

When I try to open this via double clicking the shortcut, it fails. I get
an error message:

Cannot open "C:\Program" followed by
Cannot open "Files\Test" followed by
Cannot open "Folder\abc.xls"

I can open this file directly by navigating to it using the Open menu. I
cannot open the file by navigating to it in Windows explorer and double
clicking it, same error as above. Any suggestions?

Thanks, Stuart
  #2   Report Post  
Posted to microsoft.public.excel.misc
rajkohli
 
Posts: n/a
Default Can't open spreadsheet via shortcut

The path seems to be wrong. It should be something like:

"c:\program files\test\folder\abc.txt"

not

"c:\program" "files\test" "folder\abc.xls"

Try changing the path of your shortcut.

Let us know, if the information was useful.

"Stuart" wrote:

Example: Suppose I have a shortcut that points to C:\Program Files\Test
Folder\abc.xls

When I try to open this via double clicking the shortcut, it fails. I get
an error message:

Cannot open "C:\Program" followed by
Cannot open "Files\Test" followed by
Cannot open "Folder\abc.xls"

I can open this file directly by navigating to it using the Open menu. I
cannot open the file by navigating to it in Windows explorer and double
clicking it, same error as above. Any suggestions?

Thanks, Stuart

  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Can't open spreadsheet via shortcut

Sometimes one of these works when you're having trouble with double clicking on
the file in windows explorer:

Tools|Options|General|Ignore other applications (uncheck it)

--- or ---

Close Excel and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets the windows registry to excel's
factory defaults.

Stuart wrote:

Example: Suppose I have a shortcut that points to C:\Program Files\Test
Folder\abc.xls

When I try to open this via double clicking the shortcut, it fails. I get
an error message:

Cannot open "C:\Program" followed by
Cannot open "Files\Test" followed by
Cannot open "Folder\abc.xls"

I can open this file directly by navigating to it using the Open menu. I
cannot open the file by navigating to it in Windows explorer and double
clicking it, same error as above. Any suggestions?

Thanks, Stuart


--

Dave Peterson
  #4   Report Post  
Posted to microsoft.public.excel.misc
Stuart
 
Posts: n/a
Default Can't open spreadsheet via shortcut

The unregister/reregister worked. All is now well.

Any idea how this might have occurred? It didn't happen to me, it happened
to an associate, who I believe has had this happen to her before.

Stuart

"Dave Peterson" wrote:

Sometimes one of these works when you're having trouble with double clicking on
the file in windows explorer:

Tools|Options|General|Ignore other applications (uncheck it)

--- or ---

Close Excel and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets the windows registry to excel's
factory defaults.

Stuart wrote:

Example: Suppose I have a shortcut that points to C:\Program Files\Test
Folder\abc.xls

When I try to open this via double clicking the shortcut, it fails. I get
an error message:

Cannot open "C:\Program" followed by
Cannot open "Files\Test" followed by
Cannot open "Folder\abc.xls"

I can open this file directly by navigating to it using the Open menu. I
cannot open the file by navigating to it in Windows explorer and double
clicking it, same error as above. Any suggestions?

Thanks, Stuart


--

Dave Peterson

  #5   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben
 
Posts: n/a
Default Can't open spreadsheet via shortcut

Can't recall if anyone has ever figured out why Excel will occasionally lose its
file association and "unregister" itself.

Usually occurs after a re-build of the Operating System after some disaster or
voluntary changes.

Around here, we just have the fixes due to experience and prior knowledge of
similar problems.


Gord Dibben MS Excel MVP

On Thu, 20 Apr 2006 10:44:01 -0700, Stuart
wrote:

The unregister/reregister worked. All is now well.

Any idea how this might have occurred? It didn't happen to me, it happened
to an associate, who I believe has had this happen to her before.

Stuart

"Dave Peterson" wrote:

Sometimes one of these works when you're having trouble with double clicking on
the file in windows explorer:

Tools|Options|General|Ignore other applications (uncheck it)

--- or ---

Close Excel and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets the windows registry to excel's
factory defaults.

Stuart wrote:

Example: Suppose I have a shortcut that points to C:\Program Files\Test
Folder\abc.xls

When I try to open this via double clicking the shortcut, it fails. I get
an error message:

Cannot open "C:\Program" followed by
Cannot open "Files\Test" followed by
Cannot open "Folder\abc.xls"

I can open this file directly by navigating to it using the Open menu. I
cannot open the file by navigating to it in Windows explorer and double
clicking it, same error as above. Any suggestions?

Thanks, Stuart


--

Dave Peterson




  #6   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben
 
Posts: n/a
Default Can't open spreadsheet via shortcut

Stuart

Make sure you have double-quotes around the path.

"C:\Program Files\Test Folder\abc.xls"

If you do the regserver steps outlined by Dave P. this should get taken care
of.


Gord Dibben MS Excel MVP

On Wed, 19 Apr 2006 08:41:02 -0700, Stuart
wrote:

Example: Suppose I have a shortcut that points to C:\Program Files\Test
Folder\abc.xls

When I try to open this via double clicking the shortcut, it fails. I get
an error message:

Cannot open "C:\Program" followed by
Cannot open "Files\Test" followed by
Cannot open "Folder\abc.xls"

I can open this file directly by navigating to it using the Open menu. I
cannot open the file by navigating to it in Windows explorer and double
clicking it, same error as above. Any suggestions?

Thanks, Stuart


  #7   Report Post  
Posted to microsoft.public.excel.misc
Stuart
 
Posts: n/a
Default Can't open spreadsheet via shortcut

Gord, it has double quotes. And the same thing happens when I double click
the file name in Windows Explorer. The only way I can open a file right now
is to open excel, click on "File", "Open", and browse to the desired file.
Any other method produces the error.

Stuart

"Gord Dibben" wrote:

Stuart

Make sure you have double-quotes around the path.

"C:\Program Files\Test Folder\abc.xls"

If you do the regserver steps outlined by Dave P. this should get taken care
of.


Gord Dibben MS Excel MVP

On Wed, 19 Apr 2006 08:41:02 -0700, Stuart
wrote:

Example: Suppose I have a shortcut that points to C:\Program Files\Test
Folder\abc.xls

When I try to open this via double clicking the shortcut, it fails. I get
an error message:

Cannot open "C:\Program" followed by
Cannot open "Files\Test" followed by
Cannot open "Folder\abc.xls"

I can open this file directly by navigating to it using the Open menu. I
cannot open the file by navigating to it in Windows explorer and double
clicking it, same error as above. Any suggestions?

Thanks, Stuart



  #8   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben
 
Posts: n/a
Default Can't open spreadsheet via shortcut

Stuart

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

On Wed, 19 Apr 2006 14:45:01 -0700, Stuart
wrote:

Gord, it has double quotes. And the same thing happens when I double click
the file name in Windows Explorer. The only way I can open a file right now
is to open excel, click on "File", "Open", and browse to the desired file.
Any other method produces the error.

Stuart

"Gord Dibben" wrote:

Stuart

Make sure you have double-quotes around the path.

"C:\Program Files\Test Folder\abc.xls"

If you do the regserver steps outlined by Dave P. this should get taken care
of.


Gord Dibben MS Excel MVP

On Wed, 19 Apr 2006 08:41:02 -0700, Stuart
wrote:

Example: Suppose I have a shortcut that points to C:\Program Files\Test
Folder\abc.xls

When I try to open this via double clicking the shortcut, it fails. I get
an error message:

Cannot open "C:\Program" followed by
Cannot open "Files\Test" followed by
Cannot open "Folder\abc.xls"

I can open this file directly by navigating to it using the Open menu. I
cannot open the file by navigating to it in Windows explorer and double
clicking it, same error as above. Any suggestions?

Thanks, Stuart




  #9   Report Post  
Posted to microsoft.public.excel.misc
Stuart
 
Posts: n/a
Default Can't open spreadsheet via shortcut

The path is correct in the shortcut.


"Stuart" wrote:

Example: Suppose I have a shortcut that points to C:\Program Files\Test
Folder\abc.xls

When I try to open this via double clicking the shortcut, it fails. I get
an error message:

Cannot open "C:\Program" followed by
Cannot open "Files\Test" followed by
Cannot open "Folder\abc.xls"

I can open this file directly by navigating to it using the Open menu. I
cannot open the file by navigating to it in Windows explorer and double
clicking it, same error as above. Any suggestions?

Thanks, Stuart

  #10   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Can't open spreadsheet via shortcut

What happened when you reregistered excel?

Stuart wrote:

The path is correct in the shortcut.

"Stuart" wrote:

Example: Suppose I have a shortcut that points to C:\Program Files\Test
Folder\abc.xls

When I try to open this via double clicking the shortcut, it fails. I get
an error message:

Cannot open "C:\Program" followed by
Cannot open "Files\Test" followed by
Cannot open "Folder\abc.xls"

I can open this file directly by navigating to it using the Open menu. I
cannot open the file by navigating to it in Windows explorer and double
clicking it, same error as above. Any suggestions?

Thanks, Stuart


--

Dave Peterson


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
#NAME when I open up my spreadsheet Muttley Excel Worksheet Functions 2 October 21st 05 01:20 PM
How do I automatically open a spreadsheet in a specific worksheet? GT Excel Discussion (Misc queries) 1 September 2nd 05 07:25 PM
How do I open an "excel spreadsheet file, extention .xls"? Kameron Lewis Excel Discussion (Misc queries) 1 August 21st 05 11:44 PM
windows explorer will not open an excel spreadsheet. hal Excel Discussion (Misc queries) 2 June 24th 05 02:07 AM
Cannot open a shared excel spreadsheet Kaj Excel Discussion (Misc queries) 1 January 13th 05 01:29 AM


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

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

About Us

"It's about Microsoft Excel"