Excel Online vs Desktop: Every Limitation That Matters in 2026

Microsoft ships Excel in three flavors: the full desktop application, Excel for the web (often called Excel Online), and the mobile apps. They share a name and a file format, but they are very different products. If your team is trying to standardize on the browser version — or you're wondering why your workbook breaks the moment a colleague opens it online — this is the practical rundown of what actually differs.

The Quick Verdict

Excel for the web is excellent for viewing, light editing, and real-time collaboration on straightforward workbooks. It is not a replacement for desktop Excel when your file uses macros, add-ins, advanced data tooling, or when it's simply large. And if you're pushing a spreadsheet at either version's limits, the honest answer is often that you've outgrown spreadsheets — more on that at the end.

What Excel Online Can't Do

1. VBA Macros Don't Run — At All

This is the dealbreaker for most business workbooks. Excel for the web does not execute VBA. Your macros aren't converted or partially supported; they simply don't run. A macro-enabled workbook opens in the browser, but every button, automation, and UserForm behind it is dead. Microsoft's browser-era replacement is Office Scripts (TypeScript-based), which means rebuilding your automation from scratch in a different language — and Office Scripts still can't do everything VBA does.

If macros are the reason you can't leave the desktop, that logic can be rebuilt once, properly, as a web application instead — we've covered how VBA converts to JavaScript in detail.

2. COM Add-Ins Are Desktop-Only

Classic COM add-ins — Bloomberg, Capital IQ, many industry-specific tools, and most legacy internal add-ins — only work in desktop Excel. The browser supports the newer Office.js add-in platform, which is a much smaller catalog. If your workflow depends on a ribbon add-in from 2015, the browser version won't run it.

3. Power Pivot and Advanced Data Tooling

Power Pivot data models can't be created or edited in the browser. Power Query is view-and-refresh at best online; authoring queries remains a desktop activity. Advanced connections to external databases, ODBC sources, and other workbooks either degrade or fail in the browser.

4. Large Workbooks Get Slow

Heavy files — long histories, tens of thousands of formula rows, workbook-spanning calculation chains — are noticeably slower in the browser than on a decent desktop machine, and past a certain size the browser refuses to edit at all. Desktop Excel with 64-bit memory headroom handles far more before it groans.

5. Printing and Page Layout

Page Layout view doesn't exist online, and print control is minimal. If your spreadsheet's output is a carefully formatted printed report, you'll be back on the desktop to produce it.

The Mobile Apps Are Even More Limited

The Excel mobile app is best understood as a viewer with light editing. Compared to desktop, the mobile app can't run VBA, can't author pivot tables (you can view them), offers a fraction of the formatting and data tools, and fights the screen for anything wider than a few columns. For field teams, this is the classic trap: the calculator your estimators need on site technically "opens" on their phones, but actually using a 12-column workbook on a 6-inch screen is miserable. That pain is a design problem, not a discipline problem — spreadsheet grids were never meant for phones.

Where Excel Online Genuinely Wins

Fair is fair. The browser version is better at three things: real-time co-authoring (multiple people in one file, no version emails), access from any machine without a license or install, and always being the current version of the file. If your workbook is simple and shared, Excel Online is a real upgrade over emailing .xlsx attachments.

When Neither Version Is Right

Notice the pattern in the limitations: they all bite hardest on exactly the workbooks that matter most — macro-driven tools, formula-heavy calculators, files that many people use. If you're fighting these limits, the question usually isn't "which Excel?" It's "why is this still a spreadsheet?"

A custom web application keeps your logic — every formula, every macro, recreated and verified — and sheds the constraints: it runs identically in any browser and on any phone, handles unlimited users without co-authoring conflicts, protects your formulas from accidental edits, and carries your branding instead of a spreadsheet grid. We've compared the options in depth in our Excel vs web app comparison, and our guide on how to convert Excel to a web application covers costs and approaches, including free routes.

Have a workbook stuck between versions? Send it to us — within 24 hours you'll have a free, fixed-price quote for turning it into a web app that doesn't care which Excel anyone has installed.