How to Fix Excel for iPad Freezing When Expanding Chart Data Range
Question details
Users are unable to expand chart data ranges because the Excel application freezes when dragging the data-selection handles on iPad and iPhone devices.

- Product
- Microsoft Excel for iOS
- Device & OS
- iOS / iPadOS
- Scenario
- Attempting to update an existing chart by expanding the data range using the drag handles on mobile devices.
- Observed behavior
- The Excel application becomes completely unresponsive and freezes when the user interacts with the chart's data-selection handles.
Ensure your iPad or iPhone is connected to a stable Wi-Fi network and check your App Store settings to see if you have adequate storage space for application updates.
Update Excel to Version 2.47 or Later
Microsoft has released a patch that permanently resolves the chart expansion freezing bug in newer versions of the app.
The freezing issue is a known bug associated with older builds of Excel for iOS. By updating to version 2.47 or newer, the drag handles will function correctly without locking up the application.
Locate and tap the App Store icon on your iPad or iPhone home screen.
Tap your profile picture icon located at the top right corner of the screen.
Scroll down to the 'Upcoming Automatic Updates' or 'Available Updates' section and locate Microsoft Excel.
Tap the 'Update' button next to Microsoft Excel to download and install version 2.47 or later.
Use Excel for Mac or Windows as a Workaround
If you cannot update the iOS app immediately, you can expand the chart data range on a desktop version of Excel.
Edit Charts Seamlessly with WPS Office for iPad
If you are frustrated with app freezes and software bugs in Microsoft Excel for iPad, try WPS Office. It provides a lightweight, highly compatible alternative with powerful, lag-free chart editing tools directly on your mobile device.
- 1. Download WPS Office: Go to the App Store on your iPad, search for WPS Office, and download the free application.
- 2. Open your Excel file: Launch WPS Office and locate your existing .xlsx file from your local storage or connected cloud drive.
- 3. Edit charts effortlessly: Tap on your chart to safely drag and expand the data-selection handles without experiencing any freezing issues.

Frequently Asked Questions
Why does Excel for iPad freeze when I edit my chart data?
This is a known software bug in older versions of the Excel app for iOS (versions prior to 2.47). The application fails to process the touch inputs when dragging the data-selection handles, causing the app to lock up.
Will I lose my spreadsheet data if Excel freezes during a chart update?
If AutoSave is enabled and connected to OneDrive, your previous changes are likely safe. However, the specific adjustment you were making at the moment of the freeze will probably be lost. You will need to force close the app and reopen it to check your file.
Can I type in the new data range instead of dragging the handles on iPad?
Manual text entry for chart data ranges is restricted on the iPad version compared to the desktop app. Updating your app to version 2.47+ or editing the file on a Mac/PC remains the most effective solution.
How do I check which version of Excel for iPad I am currently using?
Open the Excel app on your iPad, tap the Settings gear icon or your profile picture, and scroll down to the 'About' section to view your current version build.




