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
.
|