Microsoft KB Archive/85263

{|
 * width="100%"|

Excel's Default Template Not Used When Inserting Object

 * }

Q85263

-

The information in this article applies to:


 * Microsoft Word for Windows, versions 2.0, 2.0a, 2.0a-CD, 2.0b, 2.0c, 6.0, 6.0a, 6.0c

-

SUMMARY
In Microsoft Excel for Windows, if you create a file named SHEET.XLT and locate it in the EXCEL\XLSTART subdirectory, SHEET.XLT will be used as the default template for new worksheets. However, if you run the Insert Object command in Microsoft Word for Windows to insert an Excel worksheet, the worksheet that appears will not be based on the default template.

Workaround

 * 1) From the Insert menu in Word for Windows, choose Object. Select Microsoft Excel Worksheet, and choose the OK button.
 * 2) When the blank Excel worksheet appears, choose New from the File menu in Excel. In the New dialog box, select Worksheet, and choose the OK button. A new worksheet based on the default template will appear.
 * 3) Create the worksheet you want to embed in your Word document. Select the worksheet. From the Edit menu, choose Copy. From the File menu, choose Close. Choose the No button when prompted to save changes to the worksheet.
 * 4) Activate the original blank worksheet. From the Edit menu, choose Paste to insert the data that will be returned to Word into the worksheet.
 * 5) From the File menu, choose Update, then choose the Yes button to update the worksheet in the Word document.