Cannot do SAVE AS TEMPLATE (Excel 2003)

[Ann Scharpf]

I have a template file that I want to use as the basis for another template.
I modify the file and then, when I click "File > Save as" the only item that
appears in the "Save as type" dropdown is the .xls option. I swear I have
done this before without a problem.

How do you take one template and save it under a different name as another
template?

As always, thanks very much for your help.

 

[Gord Dibben]

Is the actual Template open?

i.e. filename.XLT

The Save As should default to *.XLT

If you have a workbook open based upon a Template, try File>Save As>File
Type and scroll down to MS Excel Template(*.xlt)



Gord Dibben MS Excel MVP

 

[Ann Scharpf]

I have tried both ways:

- Open the template directly so the .xlt is open
- Create a new document based on the template

And, as I mentioned in my post, I am using the File > Save as. The entire
list of options goes missing EXCEPT the .xls file type. The other items are
not grayed out or anything, they are just GONE ... so it is impossible to
choose .xlt.

Now that I'm investigating further, I see that when I am in a file that was
not created based on one of these two templates, "File > Save as" is working
correctly. But these two templates will not allow me to save the document as
anything but .xls.

I do know that these are the only templates I've created where I've stored
macros and created menu bars (with macros). Could that be a problem? It is
the ONLY thing I can think of that makes these files different than others on
my computer.

Thanks for trying to help me!

 

[Ann Scharpf]

Also ... I realize that I can copy the file in Windows Explorer and rename
the copy to get around this problem. I would just like to understand what's
causing it.

Thanks again!

 

[Gord Dibben]

I cannot replicate the issue on my Excel 2003 no matter what I try,
including adding a module, macros and code to create a Toolbar to an
existing *.xlt file or a new workbook based on a template.

Try Help>Detect and Repair.

Have your CD handy...........you may need it.


Gord

 

[Ann Scharpf]

Thanks for trying to help me. I work in one of those desktop maintenance
contract environments where no one has a CD, it's all done from network
servers and it takes an act of God to get something done like that. I think
I will just copy the file from Explorer, rename the copy and work with it.

I really do appreciate your effort.

 

[Dave Peterson]

One more thing to try...

Close excel
Reopen excel in safe mode
Windows start button|Run
type:
excel /safe

Open your file and try File|SaveAs.

Do you see all the options.

I'm wondering if there's a macro that's stolen the file|saveas option. By
starting excel in safe mode, you avoid any macros when excel opens (along with
other things).

If that doesn't help...

One more to try...

Close excel
Reopen excel and your workbook (normally)
Hit alt-f11 (to get to the VBE)
Hit ctrl-g (to see the immediate window)
type this and hit enter
Application.Dialogs(xlDialogSaveAs).Show

Did it work?