Office Compatibility Issues

Fix Excel Drop-Down Lists Not Working on Android or iPhone

Bushra Parveen Oct 10, 2026 872 views

Question details

The user created a workbook with data validation drop-down lists on a desktop, but these drop-downs fail to function when opened in the Excel mobile app on an Android or iPhone.

How to Fix Excel Drop-Down Lists Not Working on Android or iPhone

Product: Microsoft Excel
Device & OS: Android and iOS
Scenario: Accessing a desktop-created Excel workbook containing data validation drop-downs on a mobile device.
Observed behavior: The drop-down lists work perfectly on desktop but cannot be selected, viewed, or interacted with on the mobile application.

Before you start

Before troubleshooting, ensure your Excel mobile app is updated to the latest version from the App Store or Google Play, as older versions may have limited support for advanced data validation features.

Solution 1Recommended

Verify Mobile Compatibility and Use Cloud Sharing

Ensure your specific mobile OS supports the feature and share the file via a cloud link to prevent file corruption during email transfers.

Data validation drop-down lists created on desktop Excel generally work on iPhones, but compatibility on Android devices can sometimes vary depending on the app version and OS.

Additionally, transferring files via email can sometimes strip advanced features or cause formatting issues. Using cloud storage ensures the file remains intact.

Upload to Cloud Storage

Upload your Excel file to a cloud service like OneDrive, Dropbox, or Google Drive instead of sending it as an email attachment.

Generate a Sharing Link

Generate a sharing link from the cloud storage platform to access the file remotely.

Open on Mobile Device

Open the link on your iPhone or Android device and launch the file directly in the official Excel mobile app.

Test the Drop-Down

Tap the cell containing the data validation to see if the drop-down arrow appears and allows selection.

Verify Mobile Compatibility and Use Cloud Sharing

Microsoft Documentation Note: According to Microsoft support, drop-down lists should function natively on the iOS Excel app, but Android users may experience inconsistent behavior depending on device specifications.

Solution 2

Simplify the Data Validation Source

Complex formulas or external references in data validation can break on mobile apps. Use a simple comma-separated list or direct cell references to improve compatibility.

Free Microsoft Office alternative

Experience Seamless Mobile Spreadsheets with WPS Office

If you are facing compatibility issues with Excel drop-down lists on your mobile device, try WPS Office. It provides a lightweight, highly compatible alternative for opening, editing, and sharing spreadsheets across Windows, Mac, Android, and iOS without losing advanced formatting like data validation.

1. Download the App: Install WPS Office from the Google Play Store or Apple App Store on your mobile device.
2. Open Your Spreadsheet: Locate and open your existing .xlsx file directly in the WPS Office mobile app.
3. Use Drop-Down Lists: Tap on the cells with drop-down lists to seamlessly view and select your data validation items.

Fully compatible with Microsoft Excel (.xlsx, .xls) formats without altering your original files.Advanced features like data validation and drop-down lists work seamlessly on both Android and iOS mobile devices.Free, lightweight, and incredibly fast to load on smartphones and tablets.Familiar user interface ensuring a zero-learning-curve migration from Microsoft Office.

microsoft office alternative - wps office

Frequently Asked Questions

Why do my Excel drop-down lists work on PC but not on my Android phone?

Android Excel app compatibility can sometimes vary based on the OS version and device capabilities. Additionally, complex data validation sources (like external links or volatile formulas) are often unsupported on mobile versions of Excel.

Can I edit or create data validation rules on the Excel mobile app?

No, the Excel mobile app for iOS and Android generally only allows you to select items from an existing drop-down list. To create new drop-down menus or modify the data validation rules, you must use a desktop version of a spreadsheet program.

How do I share an Excel file to my phone without breaking drop-downs?

Avoid emailing the file as an attachment, as some email clients can alter file metadata and formatting. Instead, upload your workbook to a cloud storage service like OneDrive, Google Drive, or Dropbox, and open it directly from the cloud app on your mobile device.

Office App Problems