Office Settings & Configuration

Fix Excel 2016 Custom Lists That Disappear After Closing

Nimra MalikNimra Malik Nov 22, 2026 868 views

Question details

The user needs Excel 2016 to retain a custom list after the application closes.

Product
Microsoft Excel 2016
Device & OS
Windows
Scenario
The user creates a custom list for use in Excel and expects it to remain available in a later session.
Observed behavior
The custom list disappears after Excel closes, including when Excel is run as an administrator.
Before you start

Have the list entries ready and check whether other Excel settings also disappear after a restart. Open File > Account and look under Product Information for the Office version; select About Excel if available.

Solution 1Recommended

Create and save the custom list through Excel Options

Use Excel's Custom Lists dialog to confirm the list was added and saved before closing the application.

1
Open Custom Lists

In Excel, select File > Options > Advanced. Scroll to the General section and select Edit Custom Lists.

2
Add the entries

Select NEW LIST, enter each item on a separate line in List entries, and select Add. Alternatively, select a worksheet range and choose Import.

3
Confirm and retest

Verify that the list appears under Custom lists, then select OK in each open options dialog. Close all Excel windows, reopen Excel, and return to Edit Custom Lists to check whether it remains.

Free Microsoft Office alternative

Work with spreadsheets in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for opening and editing Excel files. It can help you move spreadsheet work between applications, though it does not repair Excel's saved settings.

Open and edit Microsoft Excel XLS and XLSX filesUse familiar spreadsheet tools to organize and sort dataMove existing Office files into a familiar workspaceUse a free, lightweight Office alternative
microsoft office alternative - wps office

Frequently Asked Questions

Where can I find custom lists in Excel 2016?

Go to File > Options > Advanced, scroll to General, and select Edit Custom Lists.

Why does my list disappear after I close Excel?

Possible causes include not selecting Add and confirming the dialogs, an add-in conflict, an Office installation issue, or a Windows profile or permissions problem.

How can I check whether an add-in is causing the problem?

Hold Ctrl while launching Excel and confirm Safe Mode. Create a test list, close and reopen Excel in Safe Mode, then check whether the list remains. If it does, test add-ins through File > Options > Add-ins.

Does running Excel as an administrator guarantee that custom lists will be saved?

No. If lists or other settings still disappear, ask an administrator to check the Windows user profile and permissions, and consider testing another user account if permitted.

Where can I check my Office version?

In Excel, open File > Account and look under Product Information. Select About Excel if available for additional version details.