How do you change the normal template in excel?

[Trasa]

I am having problems with excel opening documents. When I go to the file that
I want to open... say in my documents and I double click on the file, the
program itself opens but not the document. Someone told me that my normal
template may have been changed. I want to be able to double click on a
previously saved document and it open without having to manually go into the
file menu after Excel opens to open it. Any help would be greatly
appreciated. Thanks

Trasa

 

[Dave Peterson]

First, MSWord has a Normal template (Normal.dot). Excel doesn't.

But that's not usually the solution to the problem you're describing...

Sometimes one of these works when you're having trouble with double clicking on
the file in windows explorer:

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.

Maybe one of these will work for you.

 

[Gord Dibben]

Trasa

Forget what "someone" said about a normal template.

Try the usual fix(es) for this problem.

Tools>Options>General uncheck "Ignore other Applications"
Exit Excel and try again

If this doesn't work try to re-register Excel

Close Excel first and On the Windows Taskbar

1) Start>Run "excel.exe /unregserver"(no quotes)>OK.
2) Start>Run "excel.exe /regserver"(no quotes)>OK.
See the space between exe and /regserver

You might have to designate a full path to excel.exe.
In that case Start>Run "C:\yourpath\excel.exe /regserver"(no quotes)>OK.


Gord Dibben MS Excel MVP