1. Articles
  2. Co-authoring in Excel: Tips and Pitfalls

Decorative cover image with text: Helpful Tips

For years, Excel users have been able to collaborate on shared workbooks. By making it possible for multiple users to work together on a single file, Microsoft unlocked countless ways to boost efficiency and productivity.

With Office 365, however, the practice has evolved significantly—from “sharing” files within a workplace environment to “co-authoring” them online. (While it’s still possible to share workbooks in the old way, the feature is now hidden by default.) Unless you’re absolutely committed to traditional sharing, or require certain functionality that exists only with shared workbooks, it’s generally a good idea to adapt with the changing times. And the future, according to Microsoft, is co-authoring.

If you’re new to co-authoring in Excel, or new to collaborating on workbooks in general, here are some tips to get you started (and some pitfalls to avoid).

conceptual diagram of two laptops sharing excel documents

How co-authoring works

When you’re co-authoring in Excel, you and your colleagues can make simultaneous additions and changes to the same workbook at the same time. You see each other’s cursors in real time (each user’s cursor in its own color) and observe edits as they occur.

To enable co-authoring on an Excel workbook, begin by clicking the “Share” button in the upper-right corner of the window. If the file isn’t currently stored online (e.g., on OneDrive), you will be prompted to upload a copy.

Once the file is ready to share, you will see the following dialog box.

excel screenshot of co-authoring options

The top box allows you to specify the access settings for the file. By default, this is set to allow editing access to anyone with the link. Clicking on the box shows other possible settings. You can choose to restrict access to people in your organization, or to specific people only. You can also set an expiration date for shared access, set a password for the file, and choose whether or not to allow people to download the file.

Next, if you choose, you can enter contact information and a message, and send an email invitation directly from the dialog. Alternatively, you may copy the link and/or launch a new message in Outlook and send the invitations yourself.

Finally, if you only wish to send a copy of the file, you can choose the format (Excel workbook or PDF) and Excel will attach the file to a new email message in Outlook.

Version history is not as detailed as it was when sharing a workbook in older Excel versions. However, you can still view a list of previously saved versions and restore the file to an earlier version. This can save your skin if you run into serious troubles (simply turn the clock back in time by restoring to an earlier version) but longtime Excel power users may be frustrated by the lack of detail.

conceptual isometric diagram of two users co-authoring an excel sheet

Tips for co-authoring success (and mistakes to avoid)

1. Use an up-to-date version. Co-authoring is only available in Office 365, Office 2016, and Office Online. If one of your colleagues opens the file in an older version of Excel and then saves their changes, the file will be locked.

2. Confirm your workbook file format. Co-authoring is only supported for the following file types: .xlsx, .xlsm, and .xlsb. If you were working in another format (e.g., .xls, csv) you will first have to update the file to a compatible type.

3. Communicate, communicate, communicate. Explicitly divide up your tasks and define your roles before you begin working simultaneously. Stay out of each other’s way while editing. Keep the group chat open (look for the speech-bubble icon) and interact as needed throughout the process.

4. Confirm that all users are accessing the file via the same sharing app. If you’re working on the file in OneDrive, and a colleague has it open in Microsoft Teams or SharePoint, you’re likely headed for trouble.

5. Use caution when applying filters. When working alone in Excel, filters can help keep your work clear and organized. When co-authoring, however, the filters you create will automatically be applied for everyone who is currently editing the workbook—and could easily send them for a loop. Before you go ahead and apply your brilliant filter, use group chat to clear it with everyone else.

Consider Sheetcast

If you’re reading this article, you’ve already found your way to the Sheetcast website. Excel co-authoring can be a godsend when collaborating on everyday projects, but an Excel-based web app can unlock more power, flexibility, security, and control. If you find your needs have outgrown small-scale co-authoring, it might be time to consider an Excel to web app converter like Sheetcast.

Spend some time reviewing Sheetcast’s features and technical specs, and contact us if you have any questions.

cartoon of diverse group of professionals celebrating sheetcast for excel

More Articles:

Advanced Data Visualization Techniques in Web Apps from Excel

If you’ve ever viewed a report or infographic powered by Excel-generated graphics, you recognize that the time-tested spreadsheet application has some powerful tricks up its sleeve in terms of data visualization. Bar charts, pie charts, scatter plots, pivot tables, and more

Tips to Prevent Data Entry Errors in Excel

With Excel, your formulas, charts, and reports are only as good as the data you enter. So, if you’re responsible for entering a vast data set, it’s important to minimize the risk for error.

How to use forms in Excel … plus something better

Excel forms have improved my life. Now, I know there’s something even better (stick around to the end of this tutorial).

Do You Use Any of These Five Excel Features? If So, Try Sheetcast

Maybe you’re a bit of an Excel guru. Your workmates frequently marvel at your ability to get the most out of the app, employing functionality they never even knew existed.

Bulgaria Excel Days 2024

Sheetcast proudly announces their lead sponsorship for Bulgaria Excel Days 2024, demonstrating their dedication to the Excel Community. Join experts Ken Puls, Gašper Kamenšek, Alan Murray, and others for three days of Excel insights, presentations, and masterclasses. Don't miss Alex Martin of Sheetcast, premiering advanced new functions and workflows. Bulgaria Excel Days 2024 runs April 23-25 in Sofia, Bulgaria.

Excel Heroes: Crispo Mwangi

As the only Excel MVP in East, Central, and Southern Africa, Crispo Mwangi stands out as an Excel Influencer, business owner, and host of an MS Excel Forum, making his skills highly sought after. Despite his many commitments, this Kenyan luminary published his latest book, "Excel with PowerQuery and ChatGPT.

Excel plus Sheetcast as Your Ultimate Spreadsheet.com Alternative

Amid Spreadsheet.com's closure, Sheetcast provides a reliable solution, an Excel add-in. Created by a company of 15+ years, Sheetcast offers more than a quick fix. It pioneers innovative data management and application development, providing a secure path for those impacted by Spreadsheet.com's shutdown.

Customers Scramble for Alternatives as Spreadsheet.com Shuts Down

With Spreadsheet.com closing its doors on May 31, users are actively seeking alternatives. Sheetcast, an Excel add-in, stands out as the top solution, providing advanced capabilities and a seamless transition to reconstruct workflows into customized web apps. Sheetcast provides a smooth solution to Spreadsheet.com's shutdown

Excel Heroes: MrExcel Turns 25

Exactly 25 years ago, in 1998, Jelen published his first in a series of weekly Excel help articles at his brand-new website MrExcel.com (hardcore fans can still read that debut article thanks to the Wayback Machine). Soon afterward, he launched the MrExcel Message Board, an online community for Excel enthusiasts like himself.

The Evolution of Efficiency from Excel to Web App

For decades, Microsoft Excel has been a foundational component in the way global businesses collect, analyze, track, and report data. As powerful and flexible as Excel is on its own, however, it can now also serve as a stepping-off point to something even more dynamic and efficient.

Excel Heroes: N-nyiimock Bitanyanmi

N-nyiimock Bitanyanmi is a welcome and familiar face in the online Excel community, where he often goes by the name Justice. Behind his enthusiasm, knowledge, and eagerness to learn, however, lies a surprising fact: until he was almost an adult, he had rarely laid hands on a computer.

Ten Memorable Excel Disasters

Pretty much anyone who has ever used Excel has a horror story or two to share—a misplaced decimal, a missing minus sign, a botched cut-and-paste, or some other minor blunder with potentially major consequences.

Seven Essential Ways to Protect Your Spreadsheet

Too many of us are cautious in our daily lives, but cavalier with the safety and security of our spreadsheets.

Why Do People Still Use Spreadsheets?

Microsoft Excel debuted on the Macintosh in 1985 and came to Windows in 1987. Three and a half decades later, its name remains virtually synonymous with the very concept of “spreadsheets.”

It’s Time for Excel to Evolve: From Spreadsheets to Web Apps

The Necessary Evolution from Excel Spreadsheets to Web Apps. Like many of the greatest technologies of our time, spreadsheets can be our salvation or our downfall – and with great power comes great responsibility.

Want to Convert Excel Spreadsheets to Web Apps?

Sheetcast enables you to convert Excel spreadsheets to web apps directly in Microsoft Office, a tool you already use every day. Sheetcast is affordable, easy to learn, and has hundreds of potential uses (limited only by your imagination).