How To Make an Excel Spreadsheet Live

Last updated: August 21, 2026

Emailing a workbook around creates version chaos. A live Excel spreadsheet removes that problem: one file, one copy, everyone editing it at the same time and seeing each other's changes as they happen.

This guide covers every route people mean by "live Excel sheet": real-time co-authoring, sharing an editable link with multiple users, Excel Live in Microsoft Teams, live data that refreshes on its own, and publishing a live sheet online. It also covers what to do when the file refuses to co-author.

Table of contents

• What does "live" actually mean in Excel?
• How do you make an Excel spreadsheet live? The 4-step version
• Method 1: Make a live Excel sheet in Excel for the web
• Method 2: Co-author a live spreadsheet in desktop Excel
• How do you share a live Excel spreadsheet with multiple users?
• What is Excel Live in Microsoft Teams?
• Which live Excel method should you use?
• How do you make an Excel sheet update live from outside data?
• How do you put a live Excel sheet online for anyone to view?
• Why is my Excel spreadsheet not going live?
• Excel or Google Sheets for a live spreadsheet?
• Best practices for a live Excel spreadsheet
• FAQ

What does "live" actually mean in Excel?

"Live" gets used for three different things, and the fix is different for each one. Sort out which one you need before you start clicking.

• Live as in shared. Several people open the same workbook at once and see each other type. Microsoft calls this co-authoring.
• Live as in self-updating. The numbers refresh from an outside source such as a database, a website, or a market feed, without you retyping them.
• Live as in published. The sheet sits at a web address so anyone with the link can view the current numbers in a browser.

Rule to remember: a live Excel spreadsheet is not a setting inside the file. It is a location. The moment the workbook lives in OneDrive or SharePoint instead of your hard drive, live collaboration becomes possible.

How do you make an Excel spreadsheet live? The 4-step version

If you only want the short path, this is it. It works the same in Excel for Microsoft 365 on Windows, Mac, and the web.

1. Move the file to the cloud. Go to File > Save As (or Save a Copy) and pick OneDrive or a SharePoint library. A file on your desktop, a network drive, Dropbox, or Google Drive cannot be co-authored.
2. Save it as .xlsx, .xlsm, or .xlsb. Older .xls files and the Strict Open XML Spreadsheet format do not support co-authoring, so convert first if you need to.
3. Switch AutoSave on. The toggle sits at the top left of the Excel window and only becomes available once the file is in the cloud. AutoSave is what pushes your keystrokes to everyone else within a few seconds.
4. Click Share and send an edit link. Type in the email addresses, or copy a link, and make sure permission is set to allow editing rather than view only.

That is the whole job. Everything below is a variation on those four steps, or a fix for when one of them fails.

Method 1: Make a live Excel sheet in Excel for the web

Excel for the web, still widely called Excel Online, is the free browser version. It is the fastest route to a live sheet because the file is already in the cloud the moment you create it, and collaborators do not need Excel installed.

1. Open Excel in a browser. Go to office.com and sign in with a free Microsoft account. Create a new workbook or upload an existing one to OneDrive.
2. Click Share, top right. Enter collaborator email addresses, or select Copy link to generate a shareable link.
3. Set the permission before you send. Open the link settings and choose who the link works for, then confirm the Can edit option is selected. This is the step people skip, and it is why so many shared sheets open read-only.
4. Watch the coloured cursors. Each person editing gets a colour and a name flag on the cell they are in. Changes land for everyone within seconds.

Tip: type @ plus a colleague's name inside a comment to email them a link that opens on that exact cell.

Quotable rule: Excel for the web is the only route where your collaborators need no Excel licence at all. They need a browser and the link, nothing else.

Method 2: Co-author a live spreadsheet in desktop Excel

If you need the full desktop feature set, pivot charts, Power Query, macros, you can still work live. Microsoft calls this co-authoring, and it needs the Microsoft 365 subscription version of Excel.

1. Save to OneDrive, OneDrive for Business, or SharePoint in Microsoft 365. File > Save As, then choose the cloud location rather than a folder on the PC.
2. Turn AutoSave on. Without it, your edits sit in your copy until you press save, which defeats the point.
3. Click Share, add people, and set permission to edit.
4. Check the presence bar. The profile pictures in the top right show who else is in the file. Click one to jump to that person's selection.

Important limitation: everyone in the file has to be on a version that supports co-authoring. If one person opens the workbook in Excel 2016 or an older perpetual licence, the file locks for everyone else, even those on Microsoft 365.

Tip: Version History keeps a rolling record of the file, so an accidental delete during a live session is recoverable.

How do you share a live Excel spreadsheet with multiple users?

Sharing is where most live sheets go wrong, because the default link Excel hands you is often view only, and often restricted to your own organisation. Set the permission deliberately.

1. Click Share. In the desktop app and in the browser it sits in the top right corner.
2. Open the link settings. Select the gear icon or the line that reads something like "Anyone with the link can view".
3. Choose who the link works for. The usual options are anyone with the link, people in your organisation, people with existing access, or specific named people. Named people is the safest for anything with real numbers in it.
4. Tick the edit permission. Clear the "view only" or "block download" option if collaborators need to type in the sheet.
5. Add an expiry date or password if the option is available. Business and enterprise plans allow both on anyone-with-the-link shares.
6. Send or copy. Send emails the link with a note; Copy link gives you a URL to paste into chat, Teams, or a calendar invite.

How many people can edit at once? Microsoft does not publish a hard cap for co-authoring in Excel, but performance degrades noticeably on large workbooks once you are past a handful of simultaneous editors. If ten people need to enter data at the same time, a form feeding a sheet beats ten cursors in one grid.

Quotable rule: a share link is two decisions, not one. Who the link works for, and what they can do with it. Getting the first right and the second wrong is the most common reason a "live" sheet opens read-only.

What is Excel Live in Microsoft Teams?

Excel Live is a separate Microsoft feature, and it is what many people are looking for when they search "excel live". It lets you put a workbook into a Teams meeting so that everyone in the call can edit it inside the meeting window, rather than staring at a screen share they cannot touch.

1. Start or join a Teams meeting.
2. Click Share content.
3. Look under the Excel Live heading for your recent cloud workbooks, and pick the one you want.
4. Select Share. Everyone in the meeting gets permission to open and edit that workbook from their own device.

Worth knowing before you rely on it, per Microsoft's own documentation:

• The workbook has to be a cloud file in a modern format such as .xlsx. Local files and password-protected files do not appear.
• It is supported for meetings with 25 or fewer invitees.
• People joining on a phone or tablet can follow along and explore the sheet, but cannot edit it from inside Teams.
• Participants can scroll away from the presenter and come back, so nobody is stuck watching someone else's cursor.

Quotable rule: Excel Live is a meeting feature, not a file setting. It shares a workbook that is already live in the cloud, it does not make a local file live.

Which live Excel method should you use?

How do you make an Excel sheet update live from outside data?

Sharing keeps people in sync. This keeps the numbers in sync. Three routes, in order of how often they are the right answer.

Power Query with a refresh timer

Power Query is the built-in option and handles websites, databases, folders, and cloud services.

1. Go to Data > Get Data and pick your source, for example From Web or From Database. Enter the URL or connection details.
2. Shape the data in the Power Query Editor, then choose Close & Load.
3. Go to Data > Queries & Connections, right-click the query and choose Properties.
4. Tick Refresh every and set the interval in minutes, and tick Refresh data when opening the file so the sheet is current the moment anyone opens it.

Watch out: a scheduled refresh only runs while the workbook is open on someone's machine. A file sitting closed in OneDrive does not refresh itself. For unattended refresh you need Power BI, Power Automate, or a machine that leaves the file open.

Stocks and geography data types

For share prices, currencies, and country data you do not need any setup. Type a ticker into a cell, select it, and choose Data > Stocks. Excel converts it to a linked data type and you can pull fields with a formula. Right-click and choose Data Type > Refresh to update, or refresh all with the query refresh above.

The RTD function for true streaming

The Real-Time Data function pushes values into cells the instant the source changes, which is what trading and industrial monitoring setups use.

1. Install the RTD server your data provider supplies. Excel does not ship one.
2. Enter the formula in the pattern =RTD(ProgID, Server, Topic1, Topic2), where ProgID is the provider's identifier and Server is left blank for a local server.
3. If the values do not appear, allow the connection under File > Options > Trust Center > Trust Center Settings > External Content.

Quotable rule: Power Query refreshes on a clock, RTD streams on a change. If you need the number to move the instant the source moves, only RTD does that.

How do you put a live Excel sheet online for anyone to view?

Sometimes you do not want collaborators, you want an audience. A published sheet gives anyone with the link a read-only view that reflects the current file.

1. Save the workbook in OneDrive.
2. Open it in the browser at onedrive.com and choose File > Share > Embed.
3. Pick what to show, a whole sheet or a named range, and whether viewers can sort, filter, and type into cells to try formulas.
4. Copy either the link or the iframe embed code and paste it into your site or intranet page.

The embedded view updates when the underlying file updates, so it stays live without you republishing. Nothing typed into an embedded view is written back to your file.

Why is my Excel spreadsheet not going live?

Almost every failure traces back to one of these. Work down the table in order.

Excel or Google Sheets for a live spreadsheet?

Google Sheets is live by default, with no cloud-location step and no version requirements, and it is the easier answer if none of your collaborators own Excel. Excel is the better answer when the workbook is heavy, uses Power Query or macros, or already lives inside a Microsoft 365 tenant with the permissions you need.

You do not have to choose permanently. Excel for the web opens .xlsx files that Google Sheets exports, and Google Sheets imports .xlsx directly, so a file can move between them if the team changes.

Best practices for a live Excel spreadsheet

Keep the file fast

• Use structured tables rather than loose ranges, so formulas expand cleanly as people add rows.
• Name your ranges instead of relying on raw cell references that break when someone inserts a column.
• Go easy on volatile functions such as NOW and RAND. They recalculate on every change anyone makes, which is expensive in a shared file.

Keep the team out of trouble

• Lock the cells that contain formulas under Review > Protect Sheet and leave only the input cells unlocked.
• Use comments and @mentions instead of typing notes into spare cells.
• Check Version History after a busy session so an overwrite is caught the same day, not a month later.
• Agree one owner for structural changes. Two people inserting columns at once is the fastest way to break a live model.

FAQ

Can you make an Excel sheet live without Microsoft 365?

Yes. A free Microsoft account gives you Excel for the web at office.com, which supports real-time co-authoring at no cost. What you cannot do without a Microsoft 365 subscription is co-author from the desktop app. Google Sheets is the other free route.

How do I make an Excel spreadsheet live and shareable?

Save it to OneDrive or SharePoint, turn AutoSave on, click Share, open the link settings, choose who the link works for, and confirm the permission allows editing rather than viewing. Then send the link.

Can multiple people edit the same Excel spreadsheet at the same time?

Yes, that is co-authoring. Everyone needs the file open from OneDrive or SharePoint, in .xlsx, .xlsm, or .xlsb format, using Excel for the web or a Microsoft 365 subscription version of Excel. Each editor shows as a coloured cursor with a name flag.

Why does my Excel file say "locked for editing" when I try to co-author?

Almost always because one person has the file open in a version of Excel that does not support co-authoring, which locks it for everyone else regardless of what version they are on. Ask them to close it and reopen in the browser. The same error appears when the file is stored somewhere that does not support co-authoring, such as a network share, Dropbox, or Google Drive.

How do I make an Excel sheet live update automatically?

Pull the data in with Power Query, then open Data > Queries & Connections, right-click the query, choose Properties, and tick Refresh every with an interval plus Refresh data when opening the file. The refresh only runs while the workbook is open.

Is Excel Live the same as a live Excel spreadsheet?

No. Excel Live is a Microsoft Teams meeting feature that puts an existing cloud workbook into the meeting window so attendees can edit it during the call. A live Excel spreadsheet is the underlying setup, a cloud-stored file with sharing enabled, and it works with or without Teams.

How do I stop people from editing certain cells in a live Excel spreadsheet?

Select the cells you want to stay editable, open Format Cells > Protection and clear the Locked box, then go to Review > Protect Sheet. Every other cell becomes read-only while the sheet stays live for the unlocked input cells.

Final thoughts

A live Excel spreadsheet is a location decision more than a feature. Put the file in OneDrive or SharePoint, keep it in a modern format, turn AutoSave on, and share an edit link, and the rest follows. Add Power Query if the numbers need to update themselves, and use Excel Live in Teams when the collaboration happens in a meeting.

For more easy-to-follow Excel guides and the latest Excel Templates, visit Simple Sheets and the related articles section of this blog post.

Subscribe to Simple Sheets on YouTube for the most straightforward Excel video tutorials!

Related Articles

How to Add Months to Date in Excel

How to Print Labels From an Excel Sheet

How to Email an Excel Spreadsheet

How to Use Version History in Excel

Excel Formulas Not Calculating