File does not open...

[sc0ri0n]

Hi,

I've encountered a strange problem today with some files not opening. If a
file location or file name contained spaces excel would give a series of
errors and would not open it...

Eg. when I try to open a file c:\my documents\my excel file.xls it would
yield a series of error messages like below:

Excel could not open c:\my.xls
Excel could not open documents.xls
Excel could not open my.xls

However, if I take out the spaces, it does open. Or if I open excel and drag
& drop the file which has spaces in the file name, it would open.

any ideas?

 

[Dave Peterson]

Sometimes one of these works:

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.

An alternative might be to do:
Try Tools|Options|General|Ignore other applications (uncheck it)

 

[RWN]

Same problem,. Solved thanks to Gord Dibben.

Start>Run "excel.exe /unregserver"(no quotes and note the space before
the / mark).
Then re-register by Start>Run "excel.exe /regserver

You may have to enter your full path to excel.exe....in that case
surround
with quotes as in..... "C:\mypath\toExcel\somewhere\excel.exe"
/unregserver

 

[sc0ri0n]

Thank you for your suggestions. I will test and hope that it helps. In fact,
original complaint was that when an attached excel file was launched from
Outlook it would open excel, gives such errors and would not bring up the
file.

When I double clicked word attachment, it launched without a problem. I
suspected that excel add-ins might have caused this but even after I removed
all add-ins, only excel would come up not the file. It only worked if excel
is already launched.

Any ideas what might be causing this?

TIA!

 

[RWN]

Not an expert, but;
I've had problems in the past if I opened attachments directly. I've
since gotten into the habit of detaching them and then opening the
detached file.
Don't know why this is so - just my experience with it.

Gord's solution (a common one actually) worked like a charm on the
problem with the blanks in the file name.
IIRC I had that problem right around the time I'd encountered
difficulties trying to open a Word attachment directly.
Can't say for sure if one caused the other.

HTH

 

[sc0ri0n]

Hi,

Re-registrering excel resolved the file name issue but still files would not
open when doubleclicked. We actually got to the bottom of it and
interestingly it was because Analysis Toolpack Add-in was corrupted.

Thanks everyone who offered help.

sc0ri0n