'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Can You Change PivotTable Source Range in Excel for iPad?
Question details
The user wants to modify the source data range of an existing PivotTable using the Excel application on an iPad Pro.
- Product
- Microsoft Excel for iPad
- Device & OS
- iPadOS
- Scenario
- Attempting to edit an imported or pre-existing PivotTable on an iPad to include a new or expanded data range.
- Observed behavior
- The option to change the data source range for the PivotTable is unavailable or missing in the Excel for iPad mobile interface.
Ensure your Excel file is synced to a cloud storage service like OneDrive or iCloud, as you will need to access the document from a desktop environment to modify the PivotTable structure.
Update the PivotTable Source Range Using Desktop Excel
Since Excel for iPad does not support changing PivotTable source ranges, you must use the desktop version of Excel (Windows or Mac) to adjust your data.
Excel for iPad is a streamlined app designed primarily for viewing and light editing. Advanced data modeling features, such as editing PivotTable ranges, are restricted to the full desktop software.
On your iPad, ensure your current Excel file is saved to OneDrive, SharePoint, or iCloud so the latest version is accessible elsewhere.
Log into your Windows or Mac computer, open the desktop version of Microsoft Excel, and open the recently synced file.
Click anywhere inside the existing PivotTable to reveal the 'PivotTable Analyze' (or 'Options' in older versions) tab on the top ribbon.
Click the 'Change Data Source' button in the Data group, highlight or type in your new data range, and click 'OK'.
Save the file on your desktop. When you reopen the file in Excel for iPad, the PivotTable will reflect the new data range.
Submit a Feature Request to Microsoft
If the inability to change PivotTable sources on your iPad hinders your mobile workflow, you can formally request this feature directly from Microsoft.
Manage Complex Spreadsheets Easily with WPS Office
If you are frustrated by feature limitations in mobile spreadsheet apps, try WPS Office. It provides a lightweight, highly compatible alternative to Microsoft Office, offering robust data analysis tools across your PC, Mac, and mobile devices.
- 1. Download WPS Office: Visit the official WPS website to download the free application for your desktop or mobile device.
- 2. Open Your Excel File: Launch WPS Spreadsheet and open your existing .xlsx file directly without converting it.
- 3. Edit Seamlessly: Enjoy full editing capabilities and complete compatibility with your original Microsoft Excel formatting and formulas.
Frequently Asked Questions
Why can't I edit PivotTable data sources on Excel for iPad?
Excel for iPad is a streamlined version of the desktop software tailored for touchscreens and mobile performance. Advanced features like editing PivotTable structures, modifying source ranges, and handling complex data models are currently restricted to the full Windows and Mac versions.
Can I refresh a PivotTable in Excel for iPad?
Yes. While you cannot change the underlying data source range, you can refresh the PivotTable to reflect updated numbers within the original range. Simply tap anywhere on the PivotTable, and select the 'Refresh' option from the context menu.
How can I make my iPad PivotTable update automatically when adding new data?
The best workaround is to convert your raw data into a dynamic Excel Table on a desktop computer first. When your PivotTable's source is set to a Table rather than fixed cells (e.g., A1:D50), any new rows you add using your iPad will automatically be included in the PivotTable the next time you refresh it.
