Unsolved

This post is more than 5 years old

3 Posts

7194

May 6th, 2004 12:00

cannot double click on an excel file to open it

any excel file i open by double clicking gives me an error that the file path or the libraries are not correct. i am able to open the files from inside excel. all other ms office files are fine. my security setting is set to low. the files are not read only. i have unistalled and reinstalled ms office. i have reset the "open with" to excel again, to no avail. what diretion do i take now?

2 Intern

 • 

4.4K Posts

May 6th, 2004 23:00

Try right clicking on an Excel file in Windows explorer or my computer. Click 'open with' (not 'open'); click choose program; in the box that opens, highlight Excel by clicking on it, check the box 'always use the selected program to open this type of file', click OK. That should reset the file associations for your Excel files.

3 Posts

May 7th, 2004 12:00

didnt work.

2 Intern

 • 

4.4K Posts

May 7th, 2004 14:00

What version of Excel do you have and what version of Excel were the files saved as?

If you open the files manually in Excel and then save or save as, does that restore the double click action?

Do the files contain links to other worksheets or macros that are stored in a different relative path on your PC than they were on the PC used to create the files? Any idea what libraries the message might be referring to?

One more thing to try, is to set the association manually;

Folder options, file types tab; when the waving torch has finished scroll down to xls., click on it to highlight it, click advanced; click on open to highlight it; open should be in bold, if not click on set default. Click on edit, check that the entries are as follows:

Action: &Open

Application used to perform action: "C:\Program Files\Microsoft Office\Office10\EXCEL.EXE" /e

[this assumes that you have Office XP installed (aka Office10) at the path indicated; otherwise substitute the correct path to your Excel.exe; remember to include the " " around the path.]

Use DDE box: checked

DDE message: [open("%1")]    including [ ]

Application: Excel

DDE Application not running: leave blank

Topic: system

Click OK, OK, Apply (if you made changes), close.

3 Posts

May 13th, 2004 11:00

I went the the previously posted steps. I did make one change in the action field, I added the "&" symbol before the "open". Now I am able to the double click on the excel sheet, but I still get the sam e error message. Now a new problem has occured. I have two files in the smae folder, one named "DP-208.xls" and the other "DP-208 LOAD CALCS". When I couble click on the load clacs file, I get the DP-208 file and another error message that says "CLACS.xls" could not be found.

Top