How To Remove Template Listings in Excel


IMPORTANT : This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:
256986 Description of the Microsoft Windows Registry

IN THIS TASK

Summary

This article describes how to remove recently used templates from the most recently used (MRU) files list on the
File menu and from the Recently used templates list in the
New Workbook task pane.

back to the top

Save Existing Registry Information

WARNING : If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.
  1. Quit all Microsoft Office programs.
  2. Start Registry Editor (Regedit.exe).
  3. Expand the following subkey in the registry:
    HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel
  4. On the Registry menu, click
    Export Registry File.

    The Export Registry File dialog box appears.
  5. In the File name box, type
    C:\Export to Excel, and then click
    Save.
back to the top

How to Remove a Template from the MRU List

  1. Click Recent Files.
  2. In the Name list, click File
    number
    , where File
    number
    corresponds to the template file in the Data list that you want to remove.

    Note The values in the Name list appear in numeric order.
  3. On the Edit menu, click
    Delete, and then click Yes in the
    Confirm Value Delete message box.
  4. Rename any values in the Name list that are not in numeric order.

    To do so, follow these steps:
    1. In the Name list, right-click the value that you want to rename.
    2. Click Rename.
    3. Edit the number at the end of File
      number
      to put the values in numeric order.


      Note The list appears similar to the following:
      Name       Data
      ------------------------------------------------
      (Default) {value not set}
      File1 "C:\My Documents\myworksheet.xls"
      File2 C:\WINDOWS\Application Data\Microsoft\Templates\mytemplate2.xlt"
      File3 "C:\WINDOWS\Application Data\Templates\mytemplate3.xlt"
back to the top

How to Remove a Template from the Templates List in the Task Pane

  1. Click Recent Templates.
  2. In the Name list, click the Template
    number
    value that corresponds to the template in the Data list that you want to remove.

    Note The values in the Name list appear in alphanumeric order.
  3. On the Edit menu, click
    Delete, and then in the Confirm Value Deletemessage box, click Yes.
  4. Click the Friendly
    number
    value that has the same number as that of the Template number value that you removed in step 3.
  5. On the Edit menu, click
    Delete, and then in the Confirm Value Deletemessage box, click Yes.
  6. Rename any values in the Name list that are not in alphanumeric order.

    To do so, follow these steps:
    1. In the Name list, right-click the value that you want to rename.
    2. Click Rename.
    3. Edit the number at the end of Friendly
      number
      or Template
      number
      to put the values in alphanumeric order.

      Note The list appears similar to the following:
      Name       Data
      ------------------------------------------------
      (Default) {value not set}
      Friendly1 "Balance Sheet"
      Friendly2 ""
      Template1 "C:\Program Files\MicrosoftOffice\Templates\1033\BalanceSheet.xlt"
      Template2 "C:\WINDOWS\Application Data\Templates\mytemplate2.xlt"
  7. Quit Registry Editor.
  8. Restart the computer.
In the following registry subkey
HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Recent Templates
Friendly number and Template number both refer to the same template. The Friendly number Data value contains the name of the template, and the Template number Data value points to the path of that template file.

For example, if Friendly2 contains a Data value of Sales Invoice, Template2 will contain a Data value that is the path of the Sales Invoice template:

Name Data
------------------------------------------------
(Default) {value not set}
Friendly2 "Sales Invoice"
Template2 "C:\Program Files\Microsoft Office\Templates\1033\SalesInvoice.xlt"
Custom templates may have a Friendly number value that is empty. The corresponding Template number value will contain the full path of the location of that custom template, as in the following example:

Name Data
------------------------------------------------
(Default) {value not set}
Friendly1 ""
Template1 "C:\WINDOWS\Application Data\Templates\mytemplate.xlt"


back to the top

References

For more information about the MRU list, click the following article numbers to view the articles in the Microsoft Knowledge Base:

284896 The "Most recently used" list is missing from File menu, and the "Recently used file list" option is unavailable in Office XP and in Office 2003

280591 OFFXP: Unable to Move Menu Commands Below the List of Most Recently Used Files
307949 How To Configure a System Policy to Control the Recently Used File List in an Office XP Program
Egenskaper

Artikel-id: 822644 – senaste granskning 29 apr. 2008 – revision: 1

Feedback