filename spaces???

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Excel 2003 on Win XP all updates.
Something has changed!
With Excel NOT running, if I doubleclick an Excel filename containing spaces
to open it, I get an error message saying Excel can't find the file.
This used not to be the case.
If I remove the spaces and do the same, the file opens with no problem
If I open Excel first then double click, the file opens with no problem.
What needs resetting??
 
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.

Maybe one of these will work for you.
 
Tools | Options [General] tab
See if the box next to "Ignore other applications" is checked. If it is,
clear the box and try again.
 
Thank you for the 2 replies.
Have done all suggestions but nothong has changed
--
donwb


JLatham said:
Tools | Options [General] tab
See if the box next to "Ignore other applications" is checked. If it is,
clear the box and try again.



donbowyer said:
Excel 2003 on Win XP all updates.
Something has changed!
With Excel NOT running, if I doubleclick an Excel filename containing spaces
to open it, I get an error message saying Excel can't find the file.
This used not to be the case.
If I remove the spaces and do the same, the file opens with no problem
If I open Excel first then double click, the file opens with no problem.
What needs resetting??
 
When you ran the regserver command did Windows Installer come up and do its
thing?

Or did you get an error message?

Maybe have a look at these instructions...................

Go to Start>Settings>Control Panel>Folder Options>File Types

If using WinXP OS you would scroll down to .XLS then "Advanced">Open>Edit.

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

"C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE11\EXCEL.EXE" /e

You must have the double quotes and the <space>/e prevents a new book from
opening.

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

Application should read "Excel"(no quotes)


Gord
 
In Start>Settings>Control Panel>Folder Options>File Types>Advanced>Open>Edit.
I have:-

"C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE11\EXCEL.EXE" /e %1

When I ran the unregserver, followed by the regserver command, the Windows
Installer came up and did its thing OK.

In Start>Settings>Control Panel>Folder Options>File Types>Advanced>Open>Edit.
I now have:-

"C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE11\EXCEL.EXE" /e

ie without the <space>%1
Under these conditions, doubleclicking an *.xls file name, even without
spaces, does NOT open the file - only Excel, whereas before it did.
If I add <space>%1 after the /e, unspaced filenames now open but still not
ones with spaces.

--
donwb


Gord Dibben said:
When you ran the regserver command did Windows Installer come up and do its
thing?

Or did you get an error message?

Maybe have a look at these instructions...................

Go to Start>Settings>Control Panel>Folder Options>File Types

If using WinXP OS you would scroll down to .XLS then "Advanced">Open>Edit.

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

"C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE11\EXCEL.EXE" /e

You must have the double quotes and the <space>/e prevents a new book from
opening.

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

Application should read "Excel"(no quotes)


Gord

Thank you for the 2 replies.
Have done all suggestions but nothong has changed
 
How about the rest of the dialog at

Start>Settings>Control Panel>Folder Options>File Types>Advanced>Open>Edit.
Below have "use DDE" checked and this in the DDE message box....[open("%1")]

Application should read "Excel"(no quotes)

Looks like that?


Gord
 
Hi Gord
Yes. Exactly like that and in DDE application Not running box I have
[rem see command line]
--
donwb


Gord Dibben said:
How about the rest of the dialog at

Start>Settings>Control Panel>Folder Options>File Types>Advanced>Open>Edit.
Below have "use DDE" checked and this in the DDE message box....[open("%1")]

Application should read "Excel"(no quotes)

Looks like that?


Gord



In Start>Settings>Control Panel>Folder Options>File Types>Advanced>Open>Edit.
I have:-

"C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE11\EXCEL.EXE" /e %1

When I ran the unregserver, followed by the regserver command, the Windows
Installer came up and did its thing OK.

In Start>Settings>Control Panel>Folder Options>File Types>Advanced>Open>Edit.
I now have:-

"C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE11\EXCEL.EXE" /e

ie without the <space>%1
Under these conditions, doubleclicking an *.xls file name, even without
spaces, does NOT open the file - only Excel, whereas before it did.
If I add <space>%1 after the /e, unspaced filenames now open but still not
ones with spaces.
 
I did when I first had the problem, but I'll try it again.
--
donwb


Gord Dibben said:
Have you tried Help>Detect and Repair?

I'm running out of ideas.


Gord

Hi Gord
Yes. Exactly like that and in DDE application Not running box I have
[rem see command line]
 
Hi Gord

1. I ran Help>Detect and Repair again.
2, Selecting File Types /XLS/Advanced/Open/Edit is all as you suggested it
should be.
3. Application used to perform action ends with <space>/e WITHOUT %1.
4. The result of double clicking an XLS filename with spaces only opens Excel.
Another double click then opens the file.
5. Removing the spaces opens both Excel and the file.
6. Returning immediately to File Types /XLS/Advanced/Open/Edit I now see a
<space>%1 after the space/e. I didn't put it there.
7. Double clicking a filename with spaces now opens Excel and produces the
previously reported Cannot Find error message.
8. If I then run Run "C:\Program Files\Microsoft Office\Office11\Excel.exe"
/unregserver.
and repeat 7, the result is the same
9. If I then run Run "C:\Program Files\Microsoft Office\Office11\Excel.exe"
/regserver,
Windows Installer operates successfully.
10. Repeating 7 produces the same result as 4, and 5.
11. However File Types /XLS/Advanced/Open/Edit/ Application used to perform
action ends with <space>/e WITHOUT %1.
12. So in conclusion WITHOUT %1, the error messages don't appear, but two
double clicks are required to open a filename with spaces.
With the %1, the error message appears on the first double click of a
filename with spaces.

I just get the feeling something, somewhere else, has changed.

--
donwb


Gord Dibben said:
Have you tried Help>Detect and Repair?

I'm running out of ideas.


Gord

Hi Gord
Yes. Exactly like that and in DDE application Not running box I have
[rem see command line]
 
Great work! Looked at quite a few sites that listed going into folder options selecting the excel worksheet and editing the open command. That does not work. This worked perfectly.

Thanks much.

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.

Maybe one of these will work for you.
 
Good to know that a 4 year old post could help someone.


Gord

I fixed my problem by doing following steps:

1. Start/Run.../regedit
2. Go into HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\command
3. Change the valus of default key, remove <space>%1 from end of it.

See change:
"c:\Program Files\Microsoft Office\Office12\EXCEL.EXE" /e %1
to:
"c:\Program Files\Microsoft Office\Office12\EXCEL.EXE" /e

Then, you should be able to open XLS file which has space in path/filename now.

Hope this help.

PS, your system may not related to "Excel.Sheet.8", try them one by one, you will find out one which work for you.
Excel 2003 on Win XP all updates.
Something has changed!
With Excel NOT running, if I doubleclick an Excel filename containing spaces
to open it, I get an error message saying Excel can't find the file.
This used not to be the case.
If I remove the spaces and do the same, the file opens with no problem
If I open Excel first then double click, the file opens with no problem.
What needs resetting??
--
donwb
On Monday, October 22, 2007 5:03 PM 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.

Maybe one of these will work for you.

donbowyer wrote:
On Monday, October 22, 2007 5:08 PM HelpFrom wrote:
Tools | Options [General] tab
See if the box next to "Ignore other applications" is checked. If it is,
clear the box and try again.



"donbowyer" wrote:
On Monday, October 22, 2007 5:26 PM donbowye wrote:
Thank you for the 2 replies.
Have done all suggestions but nothong has changed
--
donwb


"JLatham" wrote:
On Monday, October 22, 2007 5:48 PM Gord Dibben wrote:
When you ran the regserver command did Windows Installer come up and do its
thing?

Or did you get an error message?

Maybe have a look at these instructions...................

Go to Start>Settings>Control Panel>Folder Options>File Types

If using WinXP OS you would scroll down to .XLS then "Advanced">Open>Edit.

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

"C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE11\EXCEL.EXE" /e

You must have the double quotes and the <space>/e prevents a new book from
opening.

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

Application should read "Excel"(no quotes)


Gord
On Tuesday, October 23, 2007 4:50 AM donbowye wrote:
In Start>Settings>Control Panel>Folder Options>File Types>Advanced>Open>Edit.
I have:-

"C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE11\EXCEL.EXE" /e %1

When I ran the unregserver, followed by the regserver command, the Windows
Installer came up and did its thing OK.

In Start>Settings>Control Panel>Folder Options>File Types>Advanced>Open>Edit.
I now have:-

"C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE11\EXCEL.EXE" /e

ie without the <space>%1
Under these conditions, doubleclicking an *.xls file name, even without
spaces, does NOT open the file - only Excel, whereas before it did.
If I add <space>%1 after the /e, unspaced filenames now open but still not
ones with spaces.

--
donwb


"Gord Dibben" wrote:
On Tuesday, October 23, 2007 4:08 PM Gord Dibben wrote:
How about the rest of the dialog at

Start>Settings>Control Panel>Folder Options>File Types>Advanced>Open>Edit.


Looks like that?


Gord
On Tuesday, October 23, 2007 5:59 PM donbowye wrote:
Hi Gord
Yes. Exactly like that and in DDE application Not running box I have
[rem see command line]
--
donwb


"Gord Dibben" wrote:
On Tuesday, October 23, 2007 7:01 PM Gord Dibben wrote:
Have you tried Help>Detect and Repair?

I am running out of ideas.


Gord
On Wednesday, October 24, 2007 4:29 AM donbowye wrote:
I did when I first had the problem, but I will try it again.
--
donwb


"Gord Dibben" wrote:
On Friday, October 26, 2007 1:47 PM donbowye wrote:
Hi Gord

1. I ran Help>Detect and Repair again.
2, Selecting File Types /XLS/Advanced/Open/Edit is all as you suggested it
should be.
3. Application used to perform action ends with <space>/e WITHOUT %1.
4. The result of double clicking an XLS filename with spaces only opens Excel.
Another double click then opens the file.
5. Removing the spaces opens both Excel and the file.
6. Returning immediately to File Types /XLS/Advanced/Open/Edit I now see a
<space>%1 after the space/e. I didn't put it there.
7. Double clicking a filename with spaces now opens Excel and produces the
previously reported Cannot Find error message.
8. If I then run Run "C:\Program Files\Microsoft Office\Office11\Excel.exe"
/unregserver.
and repeat 7, the result is the same
9. If I then run Run "C:\Program Files\Microsoft Office\Office11\Excel.exe"
/regserver,
Windows Installer operates successfully.
10. Repeating 7 produces the same result as 4, and 5.
11. However File Types /XLS/Advanced/Open/Edit/ Application used to perform
action ends with <space>/e WITHOUT %1.
12. So in conclusion WITHOUT %1, the error messages don't appear, but two
double clicks are required to open a filename with spaces.
With the %1, the error message appears on the first double click of a
filename with spaces.

I just get the feeling something, somewhere else, has changed.

--
donwb


"Gord Dibben" wrote:
On Wednesday, August 27, 2008 9:57 AM Darcy pcuser wrote:
Great work! Looked at quite a few sites that listed going into folder options selecting the excel worksheet and editing the open command. That does not work. This worked perfectly.



Thanks much.



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.



Maybe one of these will work for you.
 
Back
Top