Excel for Web: What Actually Works in the Browser

“Excel for the web” is a specific product, not a generic phrase for any browser-based spreadsheet — it is Microsoft’s own version of Excel, running at office.com or inside OneDrive and SharePoint, free with a Microsoft account. That is worth separating from the broader question of which online Excel viewer to pick when a workbook needs opening on a machine with no Excel installed: that post compares several different tools, of which Excel for the web is one. This one goes deeper on that one option — what it actually carries over from desktop Excel, and what quietly does not.

What works the same as desktop

• —Most formulas, including the modern lookup and array functions — XLOOKUP, FILTER, SORT and UNIQUE all run in Excel for the web, the same as in Microsoft 365 or Excel 2021 and later. Excel advanced functions covers what each one actually does.
• —Real-time co-authoring — open the same workbook as a colleague and you see their cursor and their edits land as they type, with no separate “merge” step afterwards.
• —Conditional formatting, PivotTables, charts, and cell formatting generally — the core of what most day-to-day spreadsheet work actually is.
• —Autosave to OneDrive or SharePoint, with version history standing in for a manual “Save As” — closing the tab does not lose work the way closing an unsaved desktop file would.

What does not carry over

The gaps are mostly the same family of thing: tools that are packaged as desktop add-ins rather than built into the core app. Excel Solver does not run in the browser at all — it is a legacy add-in, and there is no way to enable it the way File → Options → Add-ins does on desktop. The Analysis ToolPak, the source of Excel’s Data Analysis tool for things like ANOVA or regression, is the same story: present on desktop, absent from the web version.

VBA macros are the other big one. A workbook that opens fine in the browser still opens — Excel for the web does not refuse the file — but any macro inside it simply will not run, and nothing in the interface tells you that a button you clicked was supposed to do something. A macro generator for Excel covers the recorder-versus-AI-written-VBA split for building one in the first place, and either kind only runs once the file is open in desktop Excel. Third-party add-ins are more mixed: some have a web-compatible version in the Office Store, most do not.

A worked example

Say two people need to build a shared budget sheet this afternoon. Open it from a OneDrive link in a browser and both of you land in the same file — no emailing a copy back and forth, no version with “final” and “final v2” in the name. One person types a formula in column D while the other watches it appear, and a comment left on a cell shows up for both without anyone saving or refreshing. That genuinely is better than the desktop-and-email workflow it replaced.

Now say the same budget workbook has a macro button from last year that recalculates a reorder list. Click it in the browser and nothing happens — no error, no message, just silence — because the browser never runs the VBA behind it. The honest fix is opening that same file in desktop Excel for anything involving that button, not assuming the web version quietly does the same job.

Where AI actually helps, and where it does not

Asking an AI chat tool to draft a formula for a sheet you have open in the browser works exactly the same as it does for desktop Excel, because the formula language itself has not changed — only where the file lives has. OpenAI and Anthropic give the same prompting guidance either way: name the exact columns, the exact condition, and what should happen on a miss, and the formula that comes back needs far less fixing than one drafted from a vague description.

What a chat tool cannot tell you, reliably, is whether a specific feature exists in the web version at all. Feature availability by platform is exactly the kind of fast-moving detail a model’s training data goes stale on, and a widely cited survey of hallucination in large language models covers why a confident wrong answer here looks identical to a confident right one — the model has no way to check what Microsoft shipped this month. Checking the actual interface in front of you, rather than trusting a description of it, is the only reliable test.

The browser opens the same file. It does not open the same toolbar — check what is actually there before you build around it.

Checks before you build a workflow around the browser version

1. 01If the workbook has any macro, button, or cross-workbook link, open it once in desktop Excel first and confirm what it actually does before relying on the browser copy day to day.
2. 02Before starting an analysis that needs Solver or the Analysis ToolPak, check the Data tab in the browser version — if the tool is not there, it is not coming, not just hidden.
3. 03For a shared sheet with several editors, check the version history after a busy session rather than assuming everyone’s edits landed the way you expect.
4. 04If a formula uses XLOOKUP or another dynamic-array function and the file will later be opened on an older desktop install, Excel advanced functions covers which versions actually support it before someone else sees a #NAME? error instead of your result.
5. 05For anything a team will depend on repeatedly, decide in advance what you would check to notice the browser and desktop versions have quietly drifted apart — the same monitoring habit behind NIST’s AI Risk Management Framework, scaled down from a deployed system to one shared workbook.

What to do Monday

Move the sheets that are mostly about sharing and light editing — a budget, a sign-up list, a shared tracker — into the browser version and let co-authoring do the work email attachments used to. Keep anything with a macro, Solver, or the Analysis ToolPak on desktop until Microsoft actually ships it in the browser, rather than finding out mid-task that a button has gone silent. Excel tips and tricks covers the keyboard habits that work in both versions, so the move does not cost you the shortcuts you already rely on.

Knowing which tool actually has a feature, rather than assuming every version of a product behaves the same, is a small version of a bigger skill: checking a specific claim rather than trusting a plausible-sounding one. PwC has measured a real wage premium for that kind of careful AI use — 62% for workers with measurable AI skills, up from 57% the year before. Coursium teaches that judgement directly, in short lessons built around exactly this kind of worked example. Learn more about how the lessons work.