It’s 3:12 PM on a rainy Tuesday. Your laptop battery is at 18%. You’re boarding a flight in 22 minutes. Your finance lead just Slack-messaged: 'Need the Q2 vendor reconciliation before takeoff.' You open Excel. The cloud icon in the top-right corner is gray. You pause. Do you even have access to your formulas? Can you run XLOOKUP? Will your pivot table update?
Quick Answer
Yes — you can use Excel without internet. Fully. If you installed Microsoft 365 Apps (formerly Office 365 Desktop) or Excel 2019/2021, every core function works offline: formulas, charts, macros, Power Query (with cached data), conditional formatting, and even most add-ins. What *doesn’t* work are real-time co-authoring, OneDrive auto-sync, stock/Geography data types, and AI-powered features like Ideas or Copilot.
All the Methods
| Method | Steps | Best For | Limitations |
|---|---|---|---|
| Desktop Excel (MS 365 Apps) | Install via Microsoft Account → Launch Excel → Open local .xlsx file | Daily editing, complex models, VBA, large datasets | No live OneDrive sync; no Copilot or dynamic arrays if using Excel 2016 or earlier |
| Excel for the Web (cached) | Open file in Edge/Chrome → Click "Open in Excel" → Save locally → Work offline | Quick edits on shared files when internet drops mid-session | No macros, no Power Pivot, no custom number formats saved offline |
| Excel Mobile (iOS/Android) | Download file to device → Toggle Airplane Mode → Open in app | Field staff updating expense logs or inventory counts | No array formulas, no Solver, limited chart editing, no Add-ins |
| Standalone Excel Viewer (free) | Download Excel Viewer → Open read-only .xls/.xlsx files | Reviewing reports on locked-down kiosks or legacy machines | No editing, no formulas recalculating, no printing from viewer |
| Excel Starter (discontinued but still found on old PCs) | Launch pre-installed version → Open local file → Edit basic cells | Basic data entry on older Windows 7 machines with no license | Max 50 rows per sheet, no functions beyond SUM/AVERAGE, no file save-as |
Method 1 Deep Dive
Desktop Excel (MS 365 Apps) is the only method where everything works offline — if you’ve done one critical prep step first.
Open Excel. Go to File → Options → Save. Check "Save AutoRecover info every X minutes" and set it to 2. Then scroll down and uncheck "Always create backup copy." Why? Because backup copies require write access to the same folder — and if that folder lives on OneDrive and you’re offline, Excel freezes trying to verify permissions.
Now test it. Create this dataset in A1:C7:
| Vendor | Invoice Date | Amount |
|---|---|---|
| Acme Corp | 2024-03-15 | $12,450 |
| Nexus Logistics | 2024-03-18 | $8,920 |
| Veridian Systems | 2024-03-20 | $15,600 |
| TerraFab Inc | 2024-03-22 | $3,210 |
| Lumen Dynamics | 2024-03-25 | $6,780 |
| Orion Labs | 2024-03-27 | $9,430 |
Type =SUM(C2:C7) in C8. Press Enter. Turn off Wi-Fi. Press F9. The total recalculates. Now try =XLOOKUP("Nexus Logistics",A2:A7,C2:C7) in D2. It returns $8,920 — no internet required. That’s because XLOOKUP, FILTER, SORT, and SEQUENCE are compiled into the desktop app binary. They don’t call home.
Counterintuitive tip: If your workbook uses external links (e.g., '[Q1_Report.xlsx]Summary'!B5), Excel will prompt for the source file path when opened offline — unless you break the link first. Select the cell → press Alt+E+K → choose "Convert to Values". Done.
Method 2 Deep Dive
Excel for the Web (via browser) *seems* like it needs constant internet — but it has a hidden offline mode.
Step 1: Open your file in Excel for the Web (OneDrive or SharePoint). Step 2: Click the three dots (⋯) next to the filename → "Open in Excel" → let it launch the desktop app. Step 3: In desktop Excel, go to File → Info → Protect Workbook → Always Open Read-Only. Then save. Step 4: Close Excel. Disconnect internet. Reopen the file.
You’ll get a yellow banner: "This workbook was last saved while connected to the internet. Some features may be limited." Ignore it. All formulas work. Even nested IFs with DATEVALUE(). Try this in E2:E7: =IF(C2>10000,"High","Normal"). Works fine.
But here’s the catch: if your file pulls data from an online source (like a SharePoint list or Power BI dataset), those cells show #VALUE! offline — unless you cached them. To cache: select the Power Query-connected range (e.g., B2:D20), right-click → "Refresh Data" while online → then go to Data → Queries & Connections → Right-click query → Properties → Check 'Refresh data when opening file'. That saves a snapshot inside the file.
Sample cached result (F1:G6):
| Region | Q2 Forecast |
|---|---|
| North America | $412,500 |
| EMEA | $287,100 |
| APAC | $329,800 |
| LATAM | $194,300 |
| MEA | $167,900 |
Cheat Sheet
| Action | Shortcut (Windows) | Offline-Safe? |
|---|---|---|
| Recalculate all formulas | F9 | Yes |
| Convert formulas to values | Alt+E+K | Yes — prevents broken links |
| Open recent file offline | Ctrl+O, then pick from list | Yes — if saved locally |
| Insert PivotTable | Alt+N+V | Yes — uses cached data source |
| Run macro | Alt+F8 | Yes — if trusted location enabled |
| Refresh Power Query | Alt+D+F+R | Only if cached — check query properties first |
