Excel 2002, Icons

[Xkikbxr]

Hi,
I hope someone can help. I have shortcuts on my desktop to various excel
spreadsheets. The icons were working up until yesterday. They seem to have
lost the path to the work sheet. I can go through the start/programs/excel
and open them up with no problem. I deleted the icons off the desktop and
made new ones, but they still give the same message.
Windows can not find H:\ **********\2006misc.\2006sor.xls make sure you
typed the name correctly, and then try again. to search for a file, click the
start button, and then click search.

 

[Jan Karel Pieterse]

Hi Xkikbxr,

I hope someone can help. I have shortcuts on my desktop to various excel
spreadsheets. The icons were working up until yesterday. They seem to have
lost the path to the work sheet. I can go through the start/programs/excel
and open them up with no problem. I deleted the icons off the desktop and
made new ones, but they still give the same message.
Windows can not find H:\ **********\2006misc.\2006sor.xls make sure you
typed the name correctly, and then try again. to search for a file, click the
start button, and then click search.

How to reinstate Excel's ability to open files with spaces
in their name/path by double clicking:

1. Have Excel correct it

1. Choose start (Start button), Run, type:
"C:\Program Files\Microsoft Office\Office\EXCEL.EXE" /Regserver
2. Click OK

2. Do it yourself

1. Open Windows Explorer.
2. Choose from its menu: View, Options. (or View / Folder Options in Windows 98)
3. Select the File Types tab
4. Scroll to Microsoft Excel Worksheet
5. Click Edit
6. Select the OPEN entry (it should be highlighted (bolded)
7. Click Edit and check that the fields are set as follows:
a) Application used: should be EXCEL.EXE, loaded from the correct directory
b) Use DDE should be checked
c) The DDE message should be (exactly): [Open("%1")]
d) Application should be: excel
e) DDE Application not running should be empty
f) Topic should be: system
8. Click OK
9. Click Close
10. If you wish to double-click other Excel file types, e.g. template
(xlt) or workspace (xlw), select the appropriate type in the File Types
tab and repeat from step (5)

For the XLVIEWER:

- Use DDE turned OFF
- Command line: "c:\program files\xlview\xlview.exe" "%1"


Another problem might be that you have "Ignore other applications" set in tools,
options, general.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.co

 

[Xkikbxr]

Thanks for the information Jan, I tried as you typed it but the start run
C:\Program Files..... Says it's not valid "C:\Program' is not valid" So I
tried it manually and still had no effect. I will type the exact error it is
giving me....."Windows cannot find 'H:\cannondale\2005Misc\2005 SOR.xls'.
Make sure you typed the name correctly, and then try again. To search for a
file, click the start button, and then click search." Like I said I only get
the error when trying to open the excel spread sheet from a desktop Icon
short cut. The program works fine going throught the start\ programs button.
Thanks again for any help you can give.
Kik

Hi Xkikbxr,

I hope someone can help. I have shortcuts on my desktop to various excel
spreadsheets. The icons were working up until yesterday. They seem to have
lost the path to the work sheet. I can go through the start/programs/excel
and open them up with no problem. I deleted the icons off the desktop and
made new ones, but they still give the same message.
Windows can not find H:\ **********\2006misc.\2006sor.xls make sure you
typed the name correctly, and then try again. to search for a file, click the
start button, and then click search.

How to reinstate Excel's ability to open files with spaces
in their name/path by double clicking:

1. Have Excel correct it

1. Choose start (Start button), Run, type:
"C:\Program Files\Microsoft Office\Office\EXCEL.EXE" /Regserver
2. Click OK

2. Do it yourself

1. Open Windows Explorer.
2. Choose from its menu: View, Options. (or View / Folder Options in Windows 98)
3. Select the File Types tab
4. Scroll to Microsoft Excel Worksheet
5. Click Edit
6. Select the OPEN entry (it should be highlighted (bolded)
7. Click Edit and check that the fields are set as follows:
a) Application used: should be EXCEL.EXE, loaded from the correct directory
b) Use DDE should be checked
c) The DDE message should be (exactly): [Open("%1")]
d) Application should be: excel
e) DDE Application not running should be empty
f) Topic should be: system
8. Click OK
9. Click Close
10. If you wish to double-click other Excel file types, e.g. template
(xlt) or workspace (xlw), select the appropriate type in the File Types
tab and repeat from step (5)

For the XLVIEWER:

- Use DDE turned OFF
- Command line: "c:\program files\xlview\xlview.exe" "%1"


Another problem might be that you have "Ignore other applications" set in tools,
options, general.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.co

 

[Xkikbxr]

Jan, thanks for all your help. I figured it out. If you open the excel
program and got to tools/option/general tab. There is a box there that says
"Ignore other applications". Uncheck that box and the icons to the
speadsheets started working again.
Again, thanks for your help, I really do appreciate it.
KIK

Hi Xkikbxr,

I hope someone can help. I have shortcuts on my desktop to various excel
spreadsheets. The icons were working up until yesterday. They seem to have
lost the path to the work sheet. I can go through the start/programs/excel
and open them up with no problem. I deleted the icons off the desktop and
made new ones, but they still give the same message.
Windows can not find H:\ **********\2006misc.\2006sor.xls make sure you
typed the name correctly, and then try again. to search for a file, click the
start button, and then click search.

How to reinstate Excel's ability to open files with spaces
in their name/path by double clicking:

1. Have Excel correct it

1. Choose start (Start button), Run, type:
"C:\Program Files\Microsoft Office\Office\EXCEL.EXE" /Regserver
2. Click OK

2. Do it yourself

1. Open Windows Explorer.
2. Choose from its menu: View, Options. (or View / Folder Options in Windows 98)
3. Select the File Types tab
4. Scroll to Microsoft Excel Worksheet
5. Click Edit
6. Select the OPEN entry (it should be highlighted (bolded)
7. Click Edit and check that the fields are set as follows:
a) Application used: should be EXCEL.EXE, loaded from the correct directory
b) Use DDE should be checked
c) The DDE message should be (exactly): [Open("%1")]
d) Application should be: excel
e) DDE Application not running should be empty
f) Topic should be: system
8. Click OK
9. Click Close
10. If you wish to double-click other Excel file types, e.g. template
(xlt) or workspace (xlw), select the appropriate type in the File Types
tab and repeat from step (5)

For the XLVIEWER:

- Use DDE turned OFF
- Command line: "c:\program files\xlview\xlview.exe" "%1"


Another problem might be that you have "Ignore other applications" set in tools,
options, general.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.co