Microsoft Knowledge Base

XL: Sheet Based on Template with Hidden Sheet Not Inserted
Last reviewed: July 16, 1997
Article ID: Q127944
The information in this article applies to:
  • Microsoft Excel for Windows, versions 5.0, 5.0c
  • Microsoft Excel for the Macintosh, versions 5.0, 5.oa
  • Microsoft Excel for Windows NT, version 5.0
  • Microsoft Excel for Windows 95, versions 7.0, 7.0a
  • Microsoft Excel 97 for Windows

SYMPTOMS

In Microsoft Excel, when you attempt to insert a template into the active workbook using the Sheet tab shortcut menu, the sheets in the template may not be inserted into your workbook.

CAUSE

This behavior occurs if any of the sheets in the template are hidden. If any of the sheets in the template are hidden, none of the sheets (hidden or visible) will be inserted into your workbook.

WORKAROUNDS

To work around this problem, use any of the following methods.

Method 1

When you create a template that you are going to insert in another workbook, make sure that none of the sheets in the template file are hidden.

Method 2

Open the template that contains the sheets that you want to insert. You can then move or copy individual sheets from the template file to your workbook, or from your workbook to the template file.

MORE INFORMATION

When you create a template file, and save the file to the XLSTART subdirectory (Windows), or the EXCEL STARTUP FOLDER (5) folder (Macintosh), the template is available in the New list on the Sheet Tab shortcut menu. You can then insert a sheet or sheets based on the template in your workbook.

To display the Sheet Tab shortcut menu, in Microsoft Excel for Windows, click the right mouse button on a sheet tab in your workbook. In Microsoft Excel for the Macintosh, hold down the CONTROL key and click a sheet tab in your workbook.

REFERENCES

For an Overview Of Inserting New Sheets From Templates Into Workbooks, choose the Search button in Help and type: 

   templates, new sheets based on

Additional query words: 5.00 5.00c 7.00
Keywords : kbother kbother
Version : 5.00 5.00c 7.00 7.00a | 5.00 5.0
Platform : MACINTOSH WINDOWS

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: July 16, 1997
©1997 Microsoft Corporation. All rights reserved. Legal Notices.