HomeHow ToHow to Add Co-Authors to Protected Files in Microsoft Excel

How to Add Co-Authors to Protected Files in Microsoft Excel

Author

Date

Microsoft Excel users will soon be able to add co-authors to protected Excel files. With the new co-authoring support, users will be able to share and collaborate securely with the use of passwords. Sharing your Excel workbook with your colleagues to co-author works in real-time. Changes update immediately on any device you are using. And in some versions of Excel, you will see other people’s selections in different colors.

Before this update, Microsoft allows Excel users to add co-authors on regular files. However, if you are working on sensitive and confidential files with password protection enabled, the feature is not applicable. You can’t use both as you will have to remove the protection to use co-authoring. Now, it is possible to have protection and collaboration in place at the same time.

The update will be available on the Microsoft Excel app for desktop and Excel online. No mention of when it will be launched on Excel mobile apps yet.

How-to-Add-Co-Authors-to-Protected-Files-in-Microsoft-Excel
Credit: Microsoft

Microsoft is constantly updating the features on its Office apps as well as Microsoft 365 making them safer and efficient to use. The co-authoring support in protected Excel files has been on Microsoft’s radar since a lot of users have been requesting for it to be available. It seems that Microsoft listens to its users. The new capability has recently been included in the Microsoft Roadmap. Based on that record, it is still in development and the initial release date for this feature is June 2021.

How to Share your Workbook and Add Co-Authors to Protected Files in Excel

How-to-Share-your-Workbook-and-Add-Co-Authors-to-Protected-Files-in-Excel
Credit: Microsoft

To enable co-authoring, you need to save your Microsoft Excel workbook to OneDrive or SharePoint Online library.

  • If your Excel version supports co-authoring, a “Share” button appears in the upper-right corner of your workbook.
  • Select “Share” and Choose the cloud location (OneDrive or SharePoint) to upload your file.
  • Set permissions by selecting the dropdown button. You can appoint someone who can edit or just view the shared workbook.
  • Enter the email addresses of your co-worker (separate each with a semicolon.)
  • You can also add an optional message.
  • Hit the “Share” button to notify the users.
  • You can also share your Excel workbook through a link. Just click “Get a Sharing Link” at the bottom of the Share pane and share it through another medium.
Share-Workbook-for-Co-Authoring-on-Microsoft-Excel
Credit: Microsoft

Right now, if you try this on, you will be notified to remove the protection on your password-protected Microsoft Excel workbook first before you can enable sharing. However, when the new feature is released, you will be able to use co-authoring either way.

Related

More From

Fix “Sorry There Was an Error Licensing this Video” on YouTube TV

If you encountered an error while using YouTube TV, you are not alone. Many users have reported errors such as the licensing error that...

2 Ways to Find your AirPods’ Serial Number

It's always a good practice to keep a copy of your Apple device's serial numbers. There are several instances that you would need the...

Great Tips for First-Time Freelancers

Becoming a freelancer is even more common now because of the pandemic. People have lost their jobs and have started working as a freelancer....

How to Use Netflix App’s Audio-Only Option on Android Devices

Remember the days when people listen to radio dramas. It is purely an acoustic performance, where radio artists portray characters and act out scenes...

1 COMMENT

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Recent Articles

Stay Connected

Trending