Function Problems

How to Fix Cannot Change Date in Excel for iOS Due to Data Validation

Rana GarciaRana Garcia Oct 9, 2026 868 views

Question details

The user is unable to input or edit a date in an Excel cell on an iOS device because of data validation restrictions.

How to Fix Cannot Change Date in Excel for iOS Due to Data Validation
Product
Microsoft Excel
Device & OS
iOS
Scenario
Attempting to enter or change a date value in a specific cell while using the Excel app on an iPhone or iPad.
Observed behavior
Excel displays an error message stating that restricted values are not allowed in the cell, preventing the user from successfully entering the date.
Before you start

Ensure you have access to a desktop or web version of Excel, as data validation rules are best managed outside the mobile app. Verify if the worksheet is password-protected, as you will need the password or the file owner's help to unlock it before making changes.

Solution 1Recommended

Remove or Modify Data Validation Rules via Excel Desktop or Web

Since managing complex data validation is highly limited on the iOS app, using a computer is the most effective way to lift or adjust the restriction.

Data validation rules dictate exactly what type of data can be entered into a specific cell. If a date falls outside of the allowed range or format, Excel will reject it. Modifying these rules requires the desktop or web version of the application.

1
Open the Workbook on a Computer

Transfer or sync your workbook to a PC or Mac and open it using Excel for desktop or Excel for the Web.

2
Select the Restricted Cell

Click and highlight the specific cell or range of cells where you are unable to enter your date.

3
Access the Data Validation Menu

Navigate to the 'Data' tab on the top ribbon and click on 'Data Validation' located within the Data Tools group.

4
Clear or Edit the Rule

In the Data Validation dialog box, click 'Clear All' to remove the restriction entirely. Alternatively, adjust the allowed date criteria in the settings tab, then click 'OK'.

Remove or Modify Data Validation Rules via Excel Desktop or Web
Protected Worksheets: If the Data Validation option is grayed out and unclickable, the worksheet is likely protected. Go to the 'Review' tab and click 'Unprotect Sheet' to proceed.
Manage Spreadsheets Easily

Use WPS Spreadsheet to Manage Data Validation on Any Device

WPS Office offers robust spreadsheet capabilities across mobile and desktop. You can easily open your Excel files, manage data validation rules, and input dates without formatting or compatibility issues.

  1. 1. Download WPS Office: Install WPS Office on your desktop computer or iOS device for free.
  2. 2. Open the Spreadsheet: Launch WPS Spreadsheet and open the file containing the restricted cells.
  3. 3. Clear Data Validation: Highlight the problematic cell, navigate to the 'Data' tab, click 'Validation', and select 'Clear All'.
  4. 4. Input the Date: Type your desired date into the cell without facing any restriction errors, then save your file.
Fully compatible with Microsoft Excel (.xlsx, .xls) formatsCross-platform support for iOS, Windows, Mac, and AndroidAdvanced data validation and formatting tools available for free
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel say my date values are restricted?

This occurs because the author of the spreadsheet applied a 'Data Validation' rule to the cell, specifying exactly what type of data can be entered (e.g., only dates within a certain month). Any input outside these predefined rules triggers a restriction error.

Can I remove data validation directly in the Excel iOS app?

Managing and removing data validation rules is highly limited in the Excel mobile app. It is recommended to open the file in the desktop or web version of Excel to modify or clear these rules properly.

How do I know if my spreadsheet is protected?

If you cannot click the Data Validation button on the Data tab, or if you cannot make structural changes to the worksheet (like adding columns), the sheet is likely protected. You will need to go to the Review tab and select 'Unprotect Sheet', which may require a password.