Excel File Paths Contain Spaces And Wont Open

R

Ray Wells

Hi

I'm using MS Office 97 and opening Excel files just by double-clicking has
always worked fine.

A few weeks back the excel file type became associated with a very old
version of Excel 4 which was located on a network drive - don't ask me how
or why!!! I've re-associated back to Excel 97 but now, whenever I try to
open a file contained in a path which contains spaces (e.g. C:\Program
Files\My Directory\myfile.xls), Excel first tries to open each separate bit
of the path (C:\Program.xls, Files\My.xls, etc) - all of which obviously
fail - before successfully opeing the correct file.

I've checked the file association information and it all looks to be
alright - including the DDE - in fact, I've compared with a machine which
works ok and they're exactly the same.

The isn't a major issue, more an annoyance, but if anyone can tell me why
I'd appreciate it.

Thanks

Ray
 
D

Dave Peterson

Sometimes one of these works:

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.

But since you have multiple versions of excel installed, you'll want to be more
specific.

Find out the folder that contains that excel.exe for xl97.

then...
excel /unregserver
would become:
"x:\folder1\folder2\folder3\excel.exe" /unregserver

Then same thing with /regserver

Double quotes required if the path has spaces in it--but they won't hurt in any
case.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top