How to Create and Edit Pivot Tables When Using Excel for iPad
Question details
Users are looking for a way to create or modify Pivot Tables while working on an iPad, as the native mobile application lacks this functionality.
- Product
- Microsoft Excel
- Device & OS
- iPadOS
- Scenario
- Attempting to analyze and summarize data using Pivot Tables on an iPad device.
- Observed behavior
- The Excel app for iPad currently does not support creating new Pivot Tables or modifying the fields of existing ones.
Ensure you have a stable internet connection and your Microsoft account credentials ready, as you will need to access the web-based version of Office.
Use Excel for the Web via Your Browser
Since the iOS application limits Pivot Table features, logging into the web version of Excel on your iPad allows you to create and edit them fully.
Although the native Excel application on iPad doesn't support generating or adjusting Pivot Tables, Microsoft offers these full capabilities through their web-based Office suite. By using a browser on your iPad, you can bypass the app limitations.
Launch Safari, Chrome, or your preferred web browser on the iPad.
Navigate to https://www.office.com and sign in using your Microsoft account credentials.
Tap the Excel icon from the sidebar or app launcher, and open the spreadsheet containing your data.
Select your data range, navigate to the 'Insert' tab on the top ribbon, and tap 'PivotTable'. If editing an existing one, simply tap the Pivot Table to bring up the field list panel on the right side of your screen.
Try WPS Office for Your Spreadsheet and Data Needs
If you are frustrated by the limitations of mobile spreadsheet applications, WPS Office provides a lightweight, highly compatible, and feature-rich alternative. It handles complex spreadsheet tasks smoothly while offering an intuitive interface across all your devices.
- 1. Download WPS Office: Get the WPS Office app directly from the Apple App Store or the official WPS website.
- 2. Open Your Files: Launch the app and seamlessly open your existing .xlsx workbooks.
- 3. Manage Data Easily: Utilize a comprehensive set of tools tailored for mobile productivity to manage your datasets efficiently.
Frequently Asked Questions
Why is the Pivot Table feature missing from the Excel iPad app?
Microsoft has designed mobile versions of Excel to be streamlined for basic viewing and editing. As a result, advanced data analysis tools like creating and modifying Pivot Tables have not yet been implemented in the native iPadOS application.
Can I view an existing Pivot Table on my iPad?
Yes. If a workbook already contains a Pivot Table that was created on a desktop or web version of Excel, you can open the file and view the Pivot Table in the iPad app. However, you will not be able to rearrange the fields or add new data sources to it.
Does Excel for the Web require a paid subscription to use Pivot Tables?
Basic Pivot Table creation and editing are available for free when you sign into Excel for the Web with a standard Microsoft account. However, some enterprise-level data connections or advanced modeling tools might require a Microsoft 365 subscription.
Will Microsoft add Pivot Table editing to the iPad app in the future?
While Microsoft continuously updates its mobile applications based on user feedback, there is currently no official roadmap or timeline provided for implementing full Pivot Table support natively within the Excel app for iPad.
