Article ID: 133137 - View products that this article applies to.
This article was previously published under Q133137
This article has been archived. It is offered "as is" and will no longer be updated.
Microsoft Excel provides several ways for you to create a copy of a template. However, if you use the Open command on the File menu to open a template, the template opens in edit mode. In earlier versions of Microsoft Excel, when you click Open on the File menu to open a template, a copy of the template opens instead.
This article discuss ways you can create a copy of a template.
Method 1: Use the Templates folder
The template will be located on the General tab.
NOTE: If you save the template in a folder that is located inside the Templates folder, you can still create a copy of the template by clicking New on the File menu in Microsoft Excel. However, the template will be located on the tab that has the same name as the folder in which that template is stored.
Method 2: Use the Xlstart folder
If you store a template in a folder other than those listed in methods 1 through 3, you must use a macro to open a copy of the template. To open a copy of a template, use the following line in a Visual Basic macro:
ExampleThis example assumes you saved a template workbook in the c:\Xlfiles folder and called the template Template.xlt.
For additional information, please see the following article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/129279/EN-US/ )XL7: Open Command Without SHIFT Opens Template for Editing