Fix Excel 2016 Custom Lists That Disappear After Closing
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.
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.
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.
In Excel, select File > Options > Advanced. Scroll to the General section and select Edit Custom Lists.
Select NEW LIST, enter each item on a separate line in List entries, and select Add. Alternatively, select a worksheet range and choose Import.
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.
Test Excel in Safe Mode for add-in conflicts
Use this test to determine whether an add-in or another startup component is interfering with saved settings.
Repair Office and check the Windows user profile
Use these checks if the list still disappears or other Excel settings are also lost.
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.

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.




