Excel Mobile App Limitations Compared to Desktop: What Phones and Tablets Cannot Do

TL;DR: The Excel mobile app for iPhone, iPad and Android is a companion to desktop Excel, not a replacement for it. It opens the same files, but it cannot run VBA macros, has no Power Query or Power Pivot, and supports add-ins only on iPad. Editing is free only for personal files on screens of 10.1 inches or smaller. Viewing and light edits work well. Macro-driven or wide, formula-heavy workbooks do not, and for those the practical fix is a web app laid out for a phone screen.

If your team has ever opened the company quoting workbook on a phone and given up, this is why. Below is where the mobile app stops, split by device, with links to Microsoft's own pages for the main points.

What Works Well in the Excel Mobile App?

Credit where it is due. The mobile app opens .xlsx files faithfully, recalculates standard worksheet formulas, lets you edit values, sort and filter, and supports real-time co-authoring on files stored in OneDrive or SharePoint. For checking a figure before a meeting, updating a status column or reviewing a report someone else built, it is a good tool.

What Can the Excel Mobile App Not Do Compared to Desktop?

Feature	Desktop Excel	iPad	iPhone and Android
VBA macros	Run and edit	Do not run	Do not run
UserForms and ActiveX controls	UserForms on Windows and Mac, ActiveX on Windows only	Not available	Not available
Power Query	Create and refresh queries	Not supported	Not supported
Power Pivot data model	Create and edit on Windows	Not available	Not available
PivotTables	Full control	Create and edit, since January 2024	Mainly viewing existing ones
Add-ins	COM, VBA and Office Add-ins	Office Add-ins only (task pane and content), with a subscription	None
Editing without a subscription	No, it needs a licence (subscription or one-time purchase)	Only on screens of 10.1 inches or smaller, for personal files	On screens of 10.1 inches or smaller, for personal files

Sources: Microsoft states plainly that Power Query is not supported in Excel for Android and iOS, and its add-in availability table lists iPad as the only mobile platform for Excel add-ins. Features change, so treat the table as a snapshot dated October 2026.

Do Macros Run in Excel on iPhone, iPad or Android?

No, and this is the limitation that stops most business workbooks. A macro-enabled file opens on a phone and the cells are editable, but the VBA behind it does not execute. The "Calculate" button does nothing. The UserForm that guides data entry never appears. Any formatting, validation or export that a macro performs on desktop is simply skipped, usually without a warning the user will notice.

The same is true of Excel in a browser, so switching to Excel for the web on the phone does not help. We keep a running list of what VBA still cannot do online, and the page on converting Excel VBA to a web application covers the route that does work on every device.

Is the Excel Mobile App Free?

Partly. Microsoft's rule, set out on its Microsoft 365 mobile apps page, is based on screen size: core editing is free on devices with screens of 10.1 inches or smaller. On anything larger you can view for free, but creating and editing needs a qualifying Microsoft 365 subscription.

In practice that means phones and the iPad mini edit for free, while every current standard iPad, iPad Air and iPad Pro has a screen above the threshold and needs a subscription (older 9.7 inch iPads fall below it). A handful of features require a subscription on every device, including customizing PivotTable styles and layouts and adding or modifying chart elements.

Screen size is not the only test. Microsoft also requires a subscription to create and edit files saved in business storage such as OneDrive for work or SharePoint, whatever the device. A field team working on company files should assume every user needs a Microsoft 365 licence.

Why Is the Screen the Real Limitation?

Even a workbook with no macros and no advanced features can be unusable on a phone, because a spreadsheet is a grid designed for a wide monitor and a mouse. On a 6-inch touchscreen:

• You see a fragment. A 12-column estimate shows three or four columns at a time, so the inputs and the result are rarely on screen together.
• The keyboard covers half the sheet. Typing a value hides the cells you need to read next.
• Every cell is a target. One mis-tap lands in a formula cell, and unless the sheet is protected the formula is gone.
• Navigation is the work. Pinching, scrolling and switching tabs takes longer than the calculation itself.

None of this is a bug that an update will fix. A grid shows everything at once. A phone works best with one question at a time. That mismatch is why field staff phone the office and ask someone to "just run the numbers".

What Can You Do About It?

1. Build a phone-friendly input sheet. For a simple workbook with no macros, add a sheet with a single narrow column of inputs, dropdowns instead of typed choices, results directly underneath, and every other cell protected. It costs nothing and makes a small calculator tolerable on a phone.

2. Move the automation to Office Scripts and Power Automate. A Power Automate flow can run an Office Script against a workbook stored in OneDrive or SharePoint, and a flow can be started from a phone. This needs a Microsoft 365 business licence, the macros have to be rewritten in TypeScript, and there is still no equivalent of a UserForm. It suits simple automations for users who stay inside your organization.

3. Convert the workbook to a web app. The logic is rebuilt once and the interface is designed for a phone: one input per row, a numeric keypad for number fields, results that update as you type, and nothing a stray tap can break. It runs in any mobile browser, so nobody needs the Excel app or a licence. The construction cost estimating platform and the restraint length calculator are both workbooks that became browser tools that work on any phone. If the phone part of your problem is really data capture, such as inspections or timesheets, our guide to converting Excel to a web form covers the lighter options.

When Is the Mobile App Enough?

Often. If the people on phones only need to read a figure, tick off a row or update a status, the mobile app does that well and a rebuild would be a waste of money. The same goes for a workbook with one user who is usually at a desk. The case for change starts when the people who need the tool are mostly away from a desk, the workbook depends on macros, or mistakes made on a small screen cost real money.

The broader comparison of the browser version is in Excel Online vs desktop limitations, and the complete guide to converting Excel to a web application covers routes, costs and timelines. Or send us the workbook: within 24 hours you'll get a free Conversion Blueprint with a fixed price and timeline, including how the tool would look and behave on a phone.

Frequently Asked Questions

What are the main limitations of the Excel mobile app compared to desktop?

The Excel mobile app cannot run VBA macros or show UserForms, does not support Power Query or Power Pivot, and has no add-in support on iPhone or Android. PivotTables can be created on iPad but are mainly view-only on phones. On top of the feature gaps, a wide worksheet is hard to read and edit on a small touchscreen.

Can the Excel mobile app run macros?

No. Excel for iPhone, iPad and Android can open a macro-enabled workbook and edit its cells, but the VBA code does not run. Buttons assigned to macros do nothing and UserForms never appear. To run the macros, the file has to be opened in Excel for Windows or Mac, or the logic has to be rebuilt as a web app.

Is Excel free on iPhone, iPad and Android?

Viewing is free everywhere. Core editing of personal files is free on devices with screens of 10.1 inches or smaller, which covers phones and the iPad mini. On larger tablets, including every current standard iPad, iPad Air and iPad Pro, editing requires a qualifying Microsoft 365 subscription. A subscription is also needed to edit files saved in business storage such as OneDrive for work or SharePoint, on any device.

Can I create a PivotTable in the Excel mobile app?

On iPad, yes. Microsoft added PivotTable creation and editing to Excel for iPad in January 2024. On phones, plan on viewing PivotTables that were built on a desktop: iPhone can also refresh, sort and filter them, while Microsoft lists Android as view only. PivotTables that depend on a Power Pivot data model or a Power Query connection will not refresh on any mobile device.

How do I make an Excel spreadsheet usable on a phone?

For a simple workbook, build a narrow input sheet with one column of inputs, dropdowns for choices, and every other cell protected. If the workbook relies on macros or has many inputs and outputs, the practical fix is converting it to a web app with a layout designed for phones, which runs in any mobile browser without the Excel app or a licence.