Function Problems

How to Fix Excel Data Validation Drop-Down Lists After Migration

Maira Mehtab Sep 27, 2026 870 views

Question details

The user needs to fix Excel drop-down lists that fail to display options after a workbook is moved to a new computer.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Opening large spreadsheets that rely heavily on data validation features after migrating them to a new PC.
Observed behavior: The drop-down lists populate their options correctly on the old computer but stop populating on the new computer, despite having the exact same workbook settings.

Before you start

Before proceeding, check if your data validation options rely on external files, and ensure those linked files were also copied to the new computer in the same relative folder structure.

Solution 1Recommended

Isolate the Issue Using a Sanitized Test Workbook

Creating a clean copy of your workbook allows you to test whether the issue is file-specific or related to the new computer's Excel installation without risking confidential data.

When dealing with complex spreadsheets, isolating the problem is critical. By creating a sanitized version of your file, you can safely share it with IT support or test it on different machines without exposing sensitive information.

Create a Copy of Your Workbook

Open your affected workbook on the new computer, click 'File' > 'Save As', and save a new copy to your desktop.

Sanitize the Data

In the copied workbook, delete all confidential, personal, or sensitive information, replacing it with dummy data if necessary to keep the formulas intact.

Test the Drop-Down Lists

Click on the cells containing the data validation lists to see if the options populate. If they still do not work, upload this sanitized file to a cloud service like OneDrive to share with support.

Privacy Reminder: Always double-check hidden sheets and metadata to ensure no sensitive company data is accidentally left in the sanitized workbook.

Solution 2

Verify and Compare Excel Versions

Check the exact Excel version on your new computer, as version mismatches can cause feature compatibility issues.

Free Microsoft Office alternative

Use WPS Office to Seamlessly Handle Your Spreadsheets

If Microsoft Excel continues to experience functionality glitches after migrating to a new computer, consider switching to WPS Office. It provides a lightweight, reliable spreadsheet editor that fully supports advanced features like Data Validation without the migration headaches.

1. Install WPS Office: Download and install WPS Office on your new computer.
2. Open Your Spreadsheet: Launch WPS Spreadsheets, click 'Menu' > 'Open', and select your migrated workbook.
3. Use Data Validation: Click on your drop-down cells. WPS Spreadsheets will automatically populate the options based on your original rules.

Fully compatible with Microsoft Excel formats including .xlsx, .xls, and .csv.Seamlessly recognizes and preserves existing Data Validation and drop-down list rules.Free and lightweight, allowing for fast installation and smooth operation on any new PC.Familiar user interface ensures an effortless migration process without a steep learning curve.

microsoft office alternative - wps office

Frequently Asked Questions

Why do my Excel drop-down lists stop working on a new computer?

This issue typically occurs due to broken links to external source files, differences in Excel version builds between the two computers, or corrupted Office application files on the new installation.

How do I find out which version of Excel I am running?

Open your Excel application, click on 'File' in the top ribbon, and navigate to 'Account'. Your exact version and build number are displayed under the 'Product Information' heading.

What is a sanitized workbook and why do I need it?

A sanitized workbook is a duplicate of your original file that has had all sensitive, personal, and confidential data removed. It is necessary when you need to share the file with IT professionals or support forums to reproduce and diagnose technical issues safely.

Will my drop-down lists work if the source data is in another file?

Only if that external file is also moved to the new computer and the file paths in your data validation settings are updated. If the linked file is missing or the path is broken, the drop-down list will be empty.

Excel & Data Problems