Pivot Table Issues

Fix PivotTables Unavailable in Excel for Android Tablet

Maira Mehtab Sep 21, 2026 871 views

Question details

The user is unable to access PivotTable features to create or edit tables on an Android tablet using Microsoft Excel.

Product: Microsoft Excel for Android
Device & OS: Android 14
Scenario: Attempting to create a new PivotTable or modify the fields of an existing PivotTable using the Excel app on an Android tablet.
Observed behavior: PivotTable creation and editing features are missing or unavailable in the app; existing PivotTables can only be viewed.

Before you start

Verify that your workbook is saved to a cloud service like OneDrive or Google Drive, as you will need to access the file from a desktop or web environment to modify PivotTables.

Solution 1Recommended

Use Excel for Windows or macOS

Since the Android version of Excel does not support creating or editing PivotTables, switching to a desktop operating system is the most reliable solution.

Microsoft intentionally limits PivotTable functionality on Android devices. While you can view an existing PivotTable, creating new ones or altering fields is not supported by design in the Android app.

Save and sync your file

On your Android tablet, save your current Excel workbook to your connected OneDrive account.

Open the file on a desktop

Log into your Windows or Mac computer, open the Microsoft Excel desktop application, and open the recently synced file.

Create or edit the PivotTable

Navigate to the 'Insert' tab on the top ribbon and click 'PivotTable' to create a new one, or click anywhere inside an existing PivotTable to open the 'PivotTable Fields' pane on the right side of the screen to make edits.

Viewing PivotTables on Android: If you only need to analyze the data, you can still open and view pre-existing PivotTables on your Android tablet, provided they were properly created and saved on a desktop version beforehand.

Solution 2

Use Excel for the Web as a Workaround

If you do not have access to a PC or Mac, you can attempt to use Excel for the Web via your Android tablet's browser.

Free Microsoft Office alternative

Experience Powerful Spreadsheet Management with WPS Office

If feature limitations in mobile Office apps are holding you back, consider switching to WPS Office. It provides a lightweight, highly compatible alternative for viewing, editing, and managing complex spreadsheets across all your devices.

1. Download WPS Office: Visit the official WPS website or your device's app store to download and install the free WPS Office suite.
2. Open your Spreadsheet: Launch WPS Spreadsheets and open your existing .xlsx file directly without any format conversion.
3. Analyze Data Seamlessly: Utilize the comprehensive set of data tools on the WPS desktop version to create, modify, and manage your PivotTables effortlessly.

High compatibility with Microsoft Excel (.xlsx, .xls) and CSV formatsLightweight architecture that runs smoothly on Windows, Mac, Android, and iOSFamiliar user interface requiring zero learning curve for seamless migrationRobust data analysis and formatting tools available in the desktop version

microsoft office alternative - wps office

Frequently Asked Questions

Can I change PivotTable settings on the Excel Android app?

No. The Excel app for Android does not support modifying PivotTable fields, changing data sources, or adjusting settings. You must use a desktop version of Excel to make these changes.

Will reinstalling the Excel app fix the missing PivotTable features?

No, reinstalling the app will not help. The inability to create or edit PivotTables is a hardcoded feature limitation in Excel for Android, regardless of the version installed from the Google Play Store.

Are PivotTables fully supported on iPads or iPhones?

While Excel for iOS offers slightly different capabilities, full PivotTable creation and comprehensive editing are still largely restricted compared to the robust features found in Excel for Windows or macOS.

Excel & Data Problems