Share Excel Online: OneDrive, Google Drive & More

What to Have Ready Before You Share an Excel File Online

Most tutorials will tell you that sharing an Excel file is a three-click process. It is, if everyone you're sharing with has the same Microsoft 365 subscription, the same platform, and has never worked offline. That's not most workplaces. I've been sharing Excel-based reports and dashboards with department heads in a healthcare setting for years, and the edge cases are where things quietly fall apart. This guide covers the full picture: how to share Excel online through OneDrive, what to do if you don't have a Microsoft 365 subscription, and the version and platform gaps that most sharing tutorials pretend don't exist.

Before anything else, check out the broader Excel File Management and Sharing overview if you're new to how Excel handles files across environments. It'll give you context for why cloud sharing behaves differently than saving locally.

Which Cloud Platforms Actually Work for Sharing Excel Files

OneDrive is the default answer, and it works well, but it's not the only answer. OneDrive for Business and SharePoint Online are the right tools for team environments on Microsoft 365. The free personal OneDrive (5 GB) works for lighter sharing. Google Drive is a fully valid alternative if your collaborators don't have Microsoft accounts, though there's a catch covered in Step 3. Dropbox works for read-heavy sharing where you just need someone to open and view the file. Each of these is real cloud storage that can host an Excel file; they just behave differently once someone starts editing.

Real-time co-authoring (where two people type simultaneously and see each other's cursors) requires a Microsoft 365 subscription. The free tier of Excel Online lets you view and make basic edits, but it's not the same experience. If you or your collaborators are on free accounts, set those expectations before you send the link.

What to Check Before You Upload Anything

Two things to verify before you touch the Share button. First, make sure the file is saved as .xlsx, not .xls. The older format doesn't support co-authoring. Second, if you're using named ranges in the workbook, be aware that named ranges created in desktop Excel may not show up in Excel Online's Name Box.

I've documented this on both a Dell Inspiron (Windows 11, Microsoft 365) and a MacBook Air M1: the names exist in the file, but Excel Online doesn't always surface them correctly, which can produce #NAME? errors for collaborators editing in the browser. Recreating the named ranges inside Excel Online fixes it. It's obscure, but it will ruin someone's afternoon if you don't know to look for it.

If you're new to Excel's file-saving behaviors generally, the guide on how to save an Excel file properly is worth a quick read before you move files to the cloud.

---

Step 1: Upload Your Excel File to OneDrive and Generate a Share Link

With the prerequisites sorted, the upload itself is the easy part.

In the desktop Excel app, go to File → Save As → OneDrive and choose your folder. If you're uploading manually, drag the .xlsx into your OneDrive folder in File Explorer or the OneDrive web interface at onedrive.live.com. Once it's there, right-click the file and select Share.

1. Click Share from within Excel, or right-click the file in OneDrive and choose Share.
2. In the sharing dialog, click Anyone with the link to open the permissions dropdown.
3. Choose whether recipients can edit or only view. This is where most people make the mistake.
4. Copy the link, or type email addresses directly to send invitations with individual access control.

Setting Edit vs. Read-Only Permissions Before You Send the Link

Set permissions first, then share the link. The default in many configurations is "Anyone with the link can edit," which means the first person who opens the URL has full write access before you've thought about whether that's appropriate.

If you need a share Excel read-only link, select Can view in the permissions dropdown. To share an Excel spreadsheet with specific people only, type their email addresses instead of generating an open link. This restricts access to those accounts and nothing else.

For SharePoint Online environments, your IT admin may have already set organization-level defaults that override what you pick here. Worth confirming before you assume your settings stuck.

---

Step 2: Open the File in Excel Online and Collaborate in Real Time

Once the link is out, the recipient clicks it and lands in Excel Online in their browser, with no installation needed. If they have the desktop app and prefer it, they can click Open in Desktop App from the browser view. Both work for co-authoring, assuming everyone's on a supported version.

Real-time collaboration shows up as colored cell cursors with the collaborator's name attached. You'll see their edits appear within a second or two. It's not instant, and on a slow connection it can lag by several seconds, but for most shared reporting work it holds up.

What Happens When Two People Edit the Same Cell at the Same Time

Excel Online uses a "last write wins" model for simultaneous edits to the same cell. There's no merge conflict prompt: one person's change overwrites the other's silently. For most use cases this isn't a problem, because two people rarely type into the exact same cell at the exact same moment. For high-traffic cells like running totals or input fields, though, it's a real risk worth mentioning to your team upfront.

If a collaborator opens the shared file in an older desktop Excel version (Excel 2016 or 2019, for example), it may trigger a locked file error for everyone else. The older app claims exclusive access rather than entering co-authoring mode. If your collaborators are on older versions, tell them to open the link in a browser instead of the desktop app.

Excel Online handles date formatting across platforms in ways that aren't always predictable. If your workbook uses date-based formulas or conditional formatting tied to dates, test it in the browser before sending it to anyone.

---

Step 3: Share an Excel File Using Google Drive or Dropbox If You Don't Have OneDrive

Not everyone has a Microsoft 365 subscription, and that's a completely reasonable situation. Google Drive is the most capable alternative for actually editing the file. Upload the .xlsx to Drive, right-click it, and choose Open with Google Sheets, but know that this converts the file into Sheets format. Formulas usually survive. Complex named ranges, some conditional formatting, and any VBA macros do not. If your collaborators are editing in Sheets and sending back a converted file, you may lose things that were invisible until they're gone.

The safer option in Google Drive is to right-click the file, select Open with → Google Sheets, then choose to keep it in .xlsx format. It stays editable as Excel without full conversion. Dropbox is better treated as a read-heavy sharing tool: it'll host the file and generate a link, but it doesn't offer in-browser Excel editing. Good for distributing a file to people who just need to download and view it.

---

Common Mistakes When You Share Excel Files Online

Three mistakes come up more than any others.

The first is sending the share link before locking down permissions. As covered in Step 1, the default can be open edit access. A link sent to one person can be forwarded. Set permissions to specific people or restrict the link before it leaves your drafts folder.

The second is the offline sync gap. If a collaborator makes changes in their locally synced OneDrive folder while offline, those changes don't reach the shared file until they reconnect. Anyone else editing the cloud version during that window is working off a different state. OneDrive's sync icon in the system tray will indicate a file is syncing, though "syncing" and "synced" aren't always as clearly distinguished as you'd hope. For time-sensitive collaboration, confirm everyone is online before a session starts.

The third mistake is expecting tab-level access restrictions to work natively. You cannot, in standard Excel or OneDrive, restrict one collaborator to only Sheet1 while blocking them from Sheet2. Sheet-level password protection exists, but it's not a real access control: it's a deterrent. If you need genuine tab-level security, you're looking at SharePoint with custom permissions, or a restructured file where sensitive data lives in a separate workbook entirely. No cloud platform handles this for you automatically.

For more on keeping your workbook structure protected, the article on protecting workbook structure in Excel covers what's actually enforceable versus what just looks like a lock.

---

Pick one file you've been emailing back and forth this week and move it to a shared OneDrive folder instead. That's the whole habit, and in 2026, there's no good reason to still be reconciling v3_FINAL_revised.xlsx with someone's inbox attachment.