View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
GJones GJones is offline
external usenet poster
 
Posts: 132
Default Template behaving like .xls file

Hi Bryan;

Yes you have to save it out as a real XLT. If it has
macros I would also check with the other users to see if
they are being prompted about the macros and answering no
the the enable question. Not sure if that would affect it
but you for sure have to save it out as a real template.

Thanks,

Greg
-----Original Message-----
I created a spreadsheet with SQL queries and macros for

use by our sales
agents. I don't want them to overwrite it accidentally,

so I saved it and
deployed it as an .xlt. However, on the two laptops to

which I've deployed
it, it behaves like a normal .xls file, while on my

machine it behaves as I
would expect...like an .xlt file. What I mean is this:

The file is called "Experience Rating - .xlt". When *I*

open it, its new
name displays in the title bar: "Microsoft Excel -

Experience Rating - 1".
But when it's opened on the computers in question, it

shows: "Microsoft
Excel - Experience Rating - .xlt". I tried doing

a "save" instead of a
"save as..." to see if excel would prevent me from

overwriting it, but it
allowed the overwrite. I thought that wasn't supposed to

be possible if
it's saved as a template.

If it makes a difference, I actually didn't save it as

an .xlt...I renamed
it from .xls to .xlt. Should that matter?

Thanks,

Bryan


.