How to Fix Cannot Change Date in Excel for iOS Due to Data Validation
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.

- 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.
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.
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.
Transfer or sync your workbook to a PC or Mac and open it using Excel for desktop or Excel for the Web.
Click and highlight the specific cell or range of cells where you are unable to enter your date.
Navigate to the 'Data' tab on the top ribbon and click on 'Data Validation' located within the Data Tools group.
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'.

Verify Regional Settings and Number Formatting
Sometimes a perfectly valid date is rejected because it doesn't match the iOS device's regional settings or the cell's specific number format.
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. Download WPS Office: Install WPS Office on your desktop computer or iOS device for free.
- 2. Open the Spreadsheet: Launch WPS Spreadsheet and open the file containing the restricted cells.
- 3. Clear Data Validation: Highlight the problematic cell, navigate to the 'Data' tab, click 'Validation', and select 'Clear All'.
- 4. Input the Date: Type your desired date into the cell without facing any restriction errors, then save your file.

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.




