Function Problems

How to Fix Excel's Recently Used Functions List Not Updating

Steve K Sep 28, 2026 869 views

Question details

The user is experiencing an issue where Excel's Most Recently Used (MRU) functions list fails to display recently utilized formulas.

How to Fix Excel's Recently Used Functions List Not Updating

Product: Microsoft Excel
Device & OS: not provided
Scenario: Attempting to quickly access previously used formulas through the Insert Function dialog box.
Observed behavior: Functions typed manually directly into a cell or the formula bar do not get added to or update the Recently Used list.

Before you start

Verify your typical workflow for entering formulas; check whether you normally type functions directly into the formula bar or select them using the Insert Function menu, as this dictates how the list populates.

Solution 1Recommended

Use the Insert Function Dialog to Populate the List

Excel primarily tracks functions that are selected directly through its built-in user interface rather than those typed manually.

Excel's Most Recently Used (MRU) list is explicitly designed to track functions selected via the UI. Manually typing a function like '=SUM()' directly into a cell or the formula bar bypasses this tracking mechanism, preventing the list from updating.

Select a target cell

Click on the specific cell in your worksheet where you want to insert a function.

Open Insert Function

Click the 'Insert Function' (fx) button located immediately to the left of the formula bar.

Search and apply

Search for your desired function or browse the available categories, select it, and click 'OK'.

Verify the update

Reopen the Insert Function dialog; the newly selected function will now successfully appear in your Recently Used list.

Use the Insert Function Dialog to Populate the List

Best Practice: Make it a habit to use the dialog box for complex or newly discovered functions so they are automatically saved for quick access later.

Solution 2

Restart Excel and Test with a New Workbook

If using the Insert Function dialog still doesn't update the list, the issue might stem from a temporary application glitch or a corrupted workbook profile.

Efficient Formula Management

Easily Manage and Insert Functions with WPS Spreadsheet

WPS Office provides an intuitive and highly compatible Spreadsheet application where managing formulas and recently used functions is seamless and straightforward. It supports all major Excel formulas perfectly and tracks your usage intelligently.

1. Open WPS Spreadsheet: Launch WPS Office and open your spreadsheet document.
2. Navigate to Formulas: Click on the 'Formulas' tab in the top ribbon menu to access all calculation tools.
3. Insert your function: Click 'Insert Function' to browse, search, and select your required formula from the organized menu.
4. Access recent formulas: Use the 'Recently Used' category in the dialog box to quickly access your most frequent formulas without manual typing.

Accurate tracking of recently used functions to speed up your workflowFully compatible with Microsoft Excel (.xlsx) formats and standard formulasBuilt-in support for over 400 mathematical, logical, and financial functionsFree and lightweight alternative with a familiar user interface

Frequently Asked Questions

Can I force manually typed functions to appear in the Recent list?

No, Microsoft Excel's tracking mechanism generally does not add manually typed functions to the Recently Used list. You must select them through the Insert Function dialog box at least once for the system to track and display them.

How many functions are saved in Excel's Recently Used list?

Excel typically saves the last 10 functions you have inserted using the Insert Function dialog box. Once you exceed this limit, the oldest function is pushed out of the list to make room for the newest one.

Why is my Recently Used function list completely empty?

This can happen if you have recently cleared your Office cache, reset your Excel preferences, or if you are using a newly installed version of Excel where no functions have been inserted via the dialog menu yet.

Does the recently used function list sync across different devices?

No, the Most Recently Used list is saved locally on your device's registry or preference files. It does not sync across different computers or devices, even if you are logged into the same Microsoft 365 account.

Excel & Data Problems