Saving Excel template as a file, not a template default

This is pretty cheesy, but it is driving me nuts. I have a new/old computer and how it handles my template file is different than it used to be. I have a template I use all the time. Normally after I open it and go to save it, it will save as a normal .xls worksheet (yes, the company won't upgrade!). Now it wants to save as a template by default and I  have to change it with the drop down.

I have Google and looked for a option, but I don't see anything.

Any ideas?

Who is Participating?
ChloesDadConnect With a Mentor Commented:
A template can be opened in two ways, either "New"  which creates a new file based on the template, or "Open" which edits the template. These names are from Win 7, I think that XP called them "Open" and "Edit".

What I suspect is happening is that edit is happening by default when you double click on the file. When you right click on the file, the default action is highlighted in bold.

This post suggests ways to change the default operation
GeisrudConnect With a Mentor Systems AdministratorCommented:
What version of Excel are you using?  You should be able to go into options and tell it the default format in which to save.

2010: File -> Options -> Save ->Save files in this format....
2007: Click the office button, then same as above.
2003: Tools menu -> Options -> Transition tab.  In the Save Excel files as box, click the file format you want.
GeisrudSystems AdministratorCommented:
If that is set correctly to .xls, then it may be how you are actually opening the file.  Opening the template, versus creating a new file based on the template.
bvanscoy678Author Commented:
It's is 2003 Excel and it is listed as Microsoft Excel Workbook.

I am not certain what you mean by opening it as a template, versus new file based on template.

bvanscoy678Author Commented:
It was the Edit/Open Mode. I am fixing it now.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.