Excel's Default Template Not Used When Inserting Object

ID: Q85263

The information in this article applies to:

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.

MORE INFORMATION

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.

REFERENCES

"Microsoft Word for Windows User's Guide," version 2.0, page 694

"Microsoft Excel User's Guide," version 3.0, pages 553, 555-556

KBCategory: KBSubcategory: Additional query words: winword2 ole dde l&e link 2.0 2.0a word6 winword spreadsheet xls 

Keywords          : kbole
Version           : 2.0 2.0a 2.0a-CD 2.0b 2.0c
Platform          : WINDOWS

Last Reviewed: February 6, 1998