Opening XLT file with Excel XP

  • Thread starter Thread starter George
  • Start date Start date
G

George

Hi all,

I have encountered a rather weird problem in Excel 2002
(having 97 installed on the same NT system). When double-
clicking to open an XLT file, the name of the active
workbook, either displayed on top of the Excel window or
retrieved thru ActiveWorkbook.Name, is changed
automatically. For example, if the name of the XLT file is
Test.xlt, the active workbook's name changes to Test1.xlt,
having a "1" appending to the end of the name.

However, if I go through File | Open menu (in 2002 and
97), or use Right Mouse Click | Send To (to 2002 or 97),
this does not occur. MS KB has no article on this
partitular issue.

Can anyone shed some light on this?
 
But George wrote that his file is named test1.xlt.

If it were just test.xlt or test1, I think I'd understand. But George wrote
test1.xlt.

If it was a typo in George's post, then your explanation makes good sense to
me. But if it weren't a typo, I think there's something still missing.

(I've never seen the behavior that George described, though.)
 
Dave
But George wrote that his file is named test1.xlt.
Click to expand...

This from George's original post..............

For example, if the name of the XLT file is
Test.xlt, the active workbook's name changes to Test1.xlt,
having a "1" appending to the end of the name.

Gord
 
Didn't mean to be too confusing (this time!), but I meant that George wrote the
resulting file is named test1.xlt--not the original file.

When I open a template (named test.xlt), I'll get test.xlt or test1 (test# in
general). But not test1.xlt.

(Rereading this, it still looks clear as mud.)
 
Hi All,

I apologize for the confusion. When testing I didn't observe the document
that was generated by double clicking on the XLT file to have an extension
or to have been saved and responded based on the behavior that I observed.

I hope that George responds to clarify whether this was a typo in the
original post.

If in fact the file has an XLT extension then I would check to see if there
was any code being executed either by the template or from an add-in as by
default the file generated by double clicking on a template is not saved.

If you have any questions please let me know via the posting.

Regards,

Ken Laws
Microsoft Support


This posting is provided "AS IS" with no warranties, and confers no rights.
 
Back
Top