How to share and cancel sharing Microsoft Excel files with others

Thanks to its handy features, Microsoft Excel of Microsoft Office has become one of the most commonly used office tools today. One of the best features of this spreadsheet tool is the ability to share Excel files with other users.

Share a Microsoft Excel spreadsheet with others

Microsoft Excel for iOS Microsoft Excel for Android

For Microsoft Excel 2016 version:

First we need to create a new workbook by left clicking on File / New . Then select a sample table to use, select Create .

How to share and cancel sharing Microsoft Excel files with others

Click Save to Cloud and find a location where you want to save this file on your computer.

How to share and cancel sharing Microsoft Excel files with others

We can now use the Invite People shared field to Share to others.

How to share and cancel sharing Microsoft Excel files with others

But there is a small note, in this field you are required to remember and enter the exact email of the people who need to share, but for those you have done this before, you can enter their names.

How to share and cancel sharing Microsoft Excel files with others

This is also known as sharing Excel files through cloud storage, so, in addition to OneDrive , we can also save our spreadsheet file on OneDrive for Business or SharePoint Online .

With the address of each user is different, you need to separate with a comma. Can set permissions for the people you want to share so that after receiving the file, they can only read or can participate in the repair.

How to share and cancel sharing Microsoft Excel files with others

For older versions of Excel ( Microsoft Office 2010 , Microsoft Office 2007 ...) you can do the following:

Step 1 : Open the spreadsheet to share, left-click Review / Share Workbook.

How to share and cancel sharing Microsoft Excel files with others

Step 2 : The Share Workbook dialog box appears, at Editing , tick the Allow changes by more than one user at the same time . This also allows workbook merging then OK to confirm.

How to share and cancel sharing Microsoft Excel files with others

Step 3 : We can also choose to Advanced to set some other options to allow tracking and updating changes from this shared file.

How to share and cancel sharing Microsoft Excel files with others

Step 4 : Proceed to save the spreadsheet at a location accessible to others. When successful, the shared file will appear with [Shared] as shown below.

How to share and cancel sharing Microsoft Excel files with others

The file is now ready to be shared and allowed for others to view, evaluate, and edit the content in this file.

Delete others in the shared Microsoft Excel list

After you have shared your spreadsheet with others, your list of people will be saved in the Share Workbook window . You can go back here / Editing and left-click on the name of the person to delete and click on Remove User below.

How to share and cancel sharing Microsoft Excel files with others

ATTENTION:

This will prevent the deleted user from receiving the file in subsequent sharing. But with the data you have shared right now, they can still reopen, view or even participate in editing as usual.

However, when those deletion has an impact on changing the spreadsheet data, the original file sharers will receive notice and have the right to allow or not allow to save these changes from the other person.

In addition, we can also change the viewing rights of people who have just been deleted by going to View / Workbook Views / Custom Views. T ại Here you can change, delete, view of the rights that have been deleted by selecting their name and then delete.

How to share and cancel sharing Microsoft Excel files with others

Cancel sharing the Microsoft Excel file

In case your work is done and you want to stop sharing files or for some reason you do not want to continue sharing these files with others, you can disable the sharing of Microsoft Excel files. in the following way:

Still opening the Share Workbook dialog , unchecking Allow changes by more than one user at the same time ... and OK below.

How to share and cancel sharing Microsoft Excel files with others

That's all you need to remember and do when you want to share a Microsoft Excel spreadsheet file with others. In the next article, Download.com.vn will guide you how to manipulate these files, how to protect shared Excel files as well as fix related errors when many people participate in editing the content. that file.

Sign up and earn $1000 a day ⋙

Leave a Comment

How to fix the error of printing blank pages in Microsoft Excel

How to fix the error of printing blank pages in Microsoft Excel

How to fix the error of printing blank pages in Microsoft Excel. Why do some Excel documents not display data or contain blank pages when printed? Below are the reasons

How to pin Word, Excel and PowerPoint files to the corresponding app icon on the Windows 11 taskbar

How to pin Word, Excel and PowerPoint files to the corresponding app icon on the Windows 11 taskbar

How to pin Word, Excel and PowerPoint files to the corresponding app icon on the Windows 11 taskbar, How to pin Office files to the taskbar icon on Windows 11? Invite

How to fix the error of not being able to save Excel files on Windows

How to fix the error of not being able to save Excel files on Windows

How to fix the error of not being able to save an Excel file on Windows. If you can't save the Excel file, don't worry too much. Below are ways to fix the error of not being able to save the above Excel file

How to insert a picture into a cell using VBA in Excel

How to insert a picture into a cell using VBA in Excel

How to insert a picture into a cell using VBA in Excel, You can easily insert pictures into Excel spreadsheets and edit them with macro code. Here's how to insert images

How to synchronize responses on Microsoft Forms with Excel

How to synchronize responses on Microsoft Forms with Excel

How to sync Microsoft Forms responses with Excel, Want to sync Microsoft Forms responses with Excel spreadsheets? Here's how to do it easily

How to change uppercase and lowercase letters in Excel

How to change uppercase and lowercase letters in Excel

To be able to easily change uppercase and lowercase letters in Excel, Microsoft has given us some functions to convert. The following article will provide the functions to support.

IF and IFS functions in Excel: Usage and specific examples

IF and IFS functions in Excel: Usage and specific examples

The IF function in Microsoft Excel is one of the most commonly used logical functions. In the simplest sense, the IF function will return a result based on one or several input comparison data.

Learn Excel - Lesson 6: How to filter unique values ​​and delete duplicate values ​​in Excel

Learn Excel - Lesson 6: How to filter unique values ​​and delete duplicate values ​​in Excel

Filtering unique values ​​and deleting duplicate data is a basic operation that everyone needs to know when using Excel. Join us to learn how to do it in Excel!

How to determine odd and even numbers in Excel

How to determine odd and even numbers in Excel

Determining even and odd numbers is one of the regular jobs of the accounting industry. The following article will guide people to determine odd and even numbers in Excel.

3 ways to fix numeric formatting errors when using Mail Merge in Microsoft Word

3 ways to fix numeric formatting errors when using Mail Merge in Microsoft Word

One of Mail Merge's long-standing annoyances is the inability to correctly format numbers in Excel. Fortunately, we always have a way out. Here are 3 ways to fix number formatting errors in Mail Merge.

Learning Excel - Lesson 11: Importing and exporting text files

Learning Excel - Lesson 11: Importing and exporting text files

There are two simple ways to import data from a text file (.txt or .csv) into Excel. To export data from Excel to a text file, use the Save As command and change the file type from the drop-down menu.

Instructions for using Name Box in Excel

Instructions for using Name Box in Excel

Name Box in Microsoft Excel is an extremely useful feature. You already know all the uses and usage of Name Box yet? Join us to find out!

Instructions to insert checkboxes in Excel

Instructions to insert checkboxes in Excel

Microsoft Excel is a software that helps you track progress and make lists effectively, you can even insert checkboxes into spreadsheets.

Page numbering in Excel 2016/2013/2010/2007

Page numbering in Excel 2016/2013/2010/2007

When doing word processing or working on spreadsheets, one of the most important and essential things is page numbering. Not only helps users easily manipulate, but the number of Excel pages also helps us manage and work effectively

Zooper Widget for Android 2.36 - Latest Version Updates for 2024 and 2025

Zooper Widget for Android 2.36 - Latest Version Updates for 2024 and 2025

Discover the latest updates in Zooper Widget for Android. Zooper Widget is a compact, highly customizable, and battery-friendly widget with endless possibilities.

Lipp for iOS 4.4 - Make lip sync and voiceover videos on iPhone / iPad 2024, 2025

Lipp for iOS 4.4 - Make lip sync and voiceover videos on iPhone / iPad 2024, 2025

Lipp for iOS, alongside Dubsmash and Musical.ly, provides iPhone and iPad users with a new platform to create lip sync videos and dub videos readily.

How to Share Audio with TeamViewer - Latest Version Updates 2024, 2025

How to Share Audio with TeamViewer - Latest Version Updates 2024, 2025

Learn how to share audio using TeamViewer, including the latest updates for 2024 and 2025, making remote communication more effective.

Adorable Home: Latest Tips for Petting Your Cat in 2024 and 2025

Adorable Home: Latest Tips for Petting Your Cat in 2024 and 2025

Learn the latest tips on how to pet a cat in Adorable Home for optimal gameplay in 2024 and 2025. Discover what positions give you hearts.

OrangeHRM Open Source 3.2.1 - Latest Features for 2024 and Beyond

OrangeHRM Open Source 3.2.1 - Latest Features for 2024 and Beyond

Explore the latest features of OrangeHRM Open Source, a free HR management system tailored to meet evolving business needs in 2024 and 2025.

How to Fix IDM Error Not Catching Download Links - Updates for 2024 and 2025

How to Fix IDM Error Not Catching Download Links - Updates for 2024 and 2025

Fix IDM not catching file download links. Discover solutions for downloading videos, music, and more with the latest IDM updates in 2024 and 2025.

The File Converter for Android - Convert files to other formats - Updated Versions 2024, 2025

The File Converter for Android - Convert files to other formats - Updated Versions 2024, 2025

Discover the latest version of The File Converter for Android, an application that converts various file formats efficiently.

Updated Zalo Web Login Features for 2024-2025

Updated Zalo Web Login Features for 2024-2025

Explore the latest features of Zalo Web, allowing users to chat and connect seamlessly on various browsers without installation.

PDF Password Remover 6.0 - The Ultimate Solution for Password Removal in PDF Files

PDF Password Remover 6.0 - The Ultimate Solution for Password Removal in PDF Files

PDF Password Remover is a powerful tool for removing passwords and restrictions from PDF files. Download the latest version for 2024 to experience enhanced features.

Latest Instructions for Completely Removing Internet Download Manager (IDM) - Updated for 2024 and 2025

Latest Instructions for Completely Removing Internet Download Manager (IDM) - Updated for 2024 and 2025

Step-by-step instructions to completely remove Internet Download Manager (IDM) from your system in 2024 and 2025. Learn to uninstall IDM effectively and cleanly.

Mindjet MindManager 2024 & 2025 - Empower Your Mind Mapping

Mindjet MindManager 2024 & 2025 - Empower Your Mind Mapping

Discover Mindjet MindManager, an innovative software that helps individuals and teams streamline their work processes through effective mind mapping and project management.

Su Doku 2.0.0 - Latest Updates 2024 & 2025

Su Doku 2.0.0 - Latest Updates 2024 & 2025

Su DoKu 2.0.0 is an advanced Sudoku game design software that captivates enthusiasts with its simplicity and functionality. Download now and challenge yourself with Sudoku puzzles.

Google Photos for Android - Unlimited Photo and Video Storage with Latest Features in 2024, 2025

Google Photos for Android - Unlimited Photo and Video Storage with Latest Features in 2024, 2025

Discover the new features of Google Photos for Android in 2024 and 2025, including faster backup and advanced search capabilities.

Updated IQmango DVD Ripper 2024 - New Features and Enhancements

Updated IQmango DVD Ripper 2024 - New Features and Enhancements

Discover the latest version of IQmango DVD Ripper in 2024, a powerful software to easily rip, copy, convert, and back up DVDs.

When2meet - Tools to Arrange Group Meetings (Updated 2024, 2025)

When2meet - Tools to Arrange Group Meetings (Updated 2024, 2025)

When2meet is an easy-to-use group meeting scheduling tool for organizing collaborative meetings. Discover the latest features of When2meet for 2024 and 2025.