Distributing your workbook
Choose Share.
Configure permissions.
Allow editing is checked by default. Uncheck this box if you only want to allow people to view the file and not edit it.
Choose Apply.
Enter the names or email addresses of whom to share with.
Include a message (optional).
Choose Send.
Alternatively, select Copy link to obtain a link to the file.
What is the most effective way to distribute an Excel spreadsheet?
Create a shared workbook.
Select the Review option.
In the Changes group, click Share Workbook.
On the Editing tab, check the Allow multiple users to make changes at the same time box.
Save the shared workbook in a network location where other users can access it using the Save As dialog box.
Offline Excel File Sharing
If you have a local area connection, any file on the network is accessible to all users. Furthermore, any changes made to the file can be tracked. You can also specify who has access to the file.
Begin by saving the file in a location that everyone in your group can access. You can then make your file collaborative.
Restoring the Shared Workbook Feature
The Shared Workbook feature is by default hidden for Office 365 users. Because Microsoft encourages users to share workbooks online, this is the case.
Here’s how to activate the feature. If you’re using an older version of Excel, you can skip ahead to the next section, Sharing a Document.
Select File > Options > Quick Access Toolbar from the menu.
Select All Commands from the Choose Commands From drop-down menu. Scroll down the list until you find Share Workbook (Legacy) and select it.
Select the Add option.
Repeat for the following commands:
Monitor Changes (Legacy)
Keep Sharing Safe (Legacy)
Workbooks can be compared and merged.
When you’re finished, click OK.
Online Excel File Sharing
Working offline is a great solution, but it is limited by the need for a shared local drive. Working from home is clearly the better option. This is how you do it.
Utilizing OneDrive
Navigate to File > Share > Save to Cloud after opening the file.
Enter the email addresses of people you’d like to collaborate with. You can also configure the permissions.
When you’re finished, click Share.
Making Use of Google Drive
Google Drive is probably the most convenient way to collaborate on a project at the same time. Anyone with a Google account can view and edit files.
Go to Google Drive after logging into your account.
You can create a new file or upload an existing one once you’ve logged in.
After you’ve created or uploaded your document, click the Share button in the upper-right corner of the worksheet.
This will allow you to share the spreadsheet with your colleagues by entering an email address or by sharing a link.
All changes are tracked and saved automatically. You can collaborate on the document in real time, which is very convenient.
