Discussion Locked

Excel 97 won't open files with spaces

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a user thet returned from lunch and when she double clicked an excel file it broke apart the name into individual words and after multiple errors could not find the file. She can open it if she goes to the file from within Excel and/or if she takes the spaces out she can double click on it.
She is running Windows NT 4.0 with SP6 and Novell Netware. I have deleted temp files and reloaded Excel, but it has not worked.

Any ideas would be appreciated. Thanks Heather

4 replies

by Member 35711908

I've seen this happen, don't remember exactly what I did to fix it, but I do know that it had to do with spaces in the name of the file. Renaming the file without spaces was a good workaround, if she's willing to do it.

by shanghai sam

I have done the workaround. I am just curious as to whether there is a fix or not. My user is frustrated....Thank you for responding.

by shanghai sam

I have done the workaround. I am just curious as to whether there is a fix or not. My user is frustrated....Thank you for responding.

by skutts

If you open any explorer window, then hit view|options it brings up a box. depending on what OS u are using you need to hit 'file types' then scroll to the Excel file the press advanced on ME or Change on 95/98.

choose 'open' from the actions list, and hit edit.

There will be a path to the excel.exe file, followed by %1.

%1 is a string that represents the file to be opened: if you put "'s either side of this, it will treat it as a long filename:

eg:

"C:\Program Files\Microsoft Office 2000\Office\EXCEL.EXE" "%1"

this should cure the problem, and you can use this method for any other programs with the same symptoms.

any problems, send me a mail
hop i help

Rog

This discussion is closed to new replies.