Microsoft KB Archive/107221

= Using "Most Recently Used" Category in Function Wizard =

Article ID: 107221

Article Last Modified on 8/15/2003

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q107221



SUMMARY
In the Microsoft Excel Function Wizard, the "Most Recently Used" function category contains the last 10 functions you used in the Function Wizard. When you use a function in the Function Wizard, that function is added to the "Most Recently Used" list. If there are already 10 functions in the list, the last function on this list is removed from the list and the new function is added.

It is not possible to remove the "Most Recently Used" list from the Function Wizard.

When you start the Function Wizard, the function category you used last is automatically selected. For example, if the last category you used was the "Most Recently Used" category, this category will be selected when you next use the Function Wizard.

NOTE: The most recently used list in the Function Wizard is not updated if you are using a custom function or a function from an add-in. The list is updated only when you use the functions that are in the function wizard by default.



Resetting the Most Recently Used List
Although you cannot totally clear the Most Recently Used function list, you can reset it. The following instructions show you how to reset the "Most Recently Used" function category list. Use the instructions that apply to your version of Microsoft Excel. The 10 default functions on the "Most Recently Used" function category list are listed in the following table.

  Microsoft Excel       Microsoft Excel 97 version 5.0 and 7.0

Average              Sum Count                Average If                   If   Max                   Hyperlink Min                  Count Pmt                  Max Round                Sin Sum                  SumIf SumIf                Pmt Vlookup              Stdev

Microsoft Excel 7.0 and Microsoft Excel 97
WARNING: Using Registry Editor incorrectly can cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that problems resulting from the incorrect use of Registry Editor can be solved. Use Registry Editor at your own risk.

For information about how to edit the registry, view the "Changing Keys And Values" Help topic in Registry Editor (Regedit.exe) or the "Add and Delete Information in the Registry" and "Edit Registry Data" Help topics in Regedt32.exe. Note that you should back up the registry before you edit it.

To reset the "Most Recently Used" function category list, you must modify the Windows registry. To do this, follow these steps:

 Quit Microsoft Excel. On the Microsoft Windows 95 taskbar, click Start, and then click Run. In the Run box, type "regedit" (without the quotation marks) and click OK.  For your version of Microsoft Excel, locate the following key.

     Excel 97

HKEY_CURRENT_USER\Software\Microsoft\Office\8.0\Excel\Microsoft Excel

Excel 7.0 -

HKEY_CURRENT_USER\Software\Microsoft\Excel\7.0\Microsoft Excel  In the right pane, locate the entry named "MRUFuncs." Click this entry, press DELETE, and click Yes when prompted to confirm the deletion.</li> On the Registry menu, click Exit.</li> Start Microsoft Excel.</li></ol>

When you start the Function Wizard, the list of functions is reset to the 10 default functions.

Microsoft Excel Version 5.0 (Windows)
To reset the Most Recently Used list, edit the Excel5.ini file (usually in your Windows directory). To do this, follow these steps:


 * 1) Quit Microsoft Excel.
 * 2) Open the Excel5.ini file by using a text editor, such as Notepad or the Edit program included with MS-DOS 5.x or 6.x.
 * 3) In the [Microsoft Excel] section of the Excel5.ini, change the line that begins with "MRUFuncs=." Delete all characters following the equal sign so that the line contains only the following text:

MRUFuncs=
 * 1) Save the Excel5.ini file and quit the text editor.

When you start the Function Wizard, the list of functions is reset to the 10 default functions.

Microsoft Excel Version 5.0 (Macintosh)
To reset the Most Recently Used list, you must delete the preferences file for Microsoft Excel. Note that you will lose your other custom settings for the Microsoft Excel environment if you delete this file.

To delete your Microsoft Excel preferences file, locate the following file

<pre class="fixed_text">  <Hard disk name>: System Folder: Preferences: Excel Settings (5)

and drag it into the trash.

Preventing the Most Recently Used Function List from Being Updated
The only way to prevent the Most Recently Used Function list from being updated is to not use the Function Wizard. Functions that are entered without using the Function Wizard are not added to the Most Recently Used Function list.

Additional query words: 8.00 97 XL97 XL7 XL5 MRU XL

Keywords: kbhowto KB107221

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.