How to Share an Excel File Collaboratively

This guide will explain how to share an Excel file so that it can be edited and viewed in real-time by multiple users simultaneously. This feature is useful for work teams that need to collaborate on a project, allowing all members to view and make changes to the document in a synchronized manner.

Sharing an Excel file is particularly useful for:

• Work teams: Allows multiple people to work on the same document without having to send it back and forth via email.
• Collaborative projects: Facilitates real-time collaboration, showing the changes made by each user immediately.
• Data management: Allows for a single, constantly updated reference point, avoiding duplicate or outdated versions.

This guide is intended for users who use Excel as part of the Microsoft 365 suite, both on Windows and macOS, and who want to share their files via OneDrive or other sharing platforms.

Prerequisites

• Hardware: Computer with Windows or macOS operating system
• Software: Microsoft Excel included in the Microsoft 365 suite
• Account: Microsoft account for access to OneDrive
• Internet Connection: Active connection for access to OneDrive and file synchronization

How to Share an Excel File on OneDrive from PC

This guide will explain step-by-step how to share an Excel file on OneDrive using the software included in the Microsoft 365 suite for Windows or macOS.

• Save the workbook to OneDrive. If you don't have an account yet, check out the guide on how OneDrive works.
• Launch Excel and open the file of interest.
• If you are using Windows, click on File > Save As.
• Select the OneDrive profile associated with your Microsoft account, assign a name to the document, and press Save or Save a Copy.
• Press the Share button at the top right of the worksheet.
• Click on Share and set the sharing preferences according to your needs.
• If you want to share only the active sheet, select Share this sheet from the Share menu and copy the generated link.
• If you are using a Mac, press the Share button, assign a name to the document, and click on Upload.
• Verify that the AutoSave button is active.
• Click on Share again and choose Invite people.

How to Share an Excel File and Work Simultaneously

• On Windows, press the pencil icon in the Send link section.
• Select Can edit and press Sharing settings.
• Choose between Anyone or Specific people.
• Define an expiration date, if necessary.
• Press Apply and type the recipients' references.
• Write a message, if desired, and press Send.
• If you prefer to manually manage the link sending, press Copy in the Copy link section.
• On Mac, enter the recipients, an optional message, and select the option to allow edits.
• To use different channels, choose Copy link or Send a copy from the Share menu.
• The recipient will need to click on the received link and, if requested, log in with their Microsoft account.

How to Share an Excel File as Read-Only

• On Windows, press Share > Share and select Can view.
• Press Sharing settings and define the type of recipient users.
• Fill in the To: field with the recipients and type an optional message.
• Press Send.
• On Mac, press Share, select Copy link, and choose View only.
• Manage the invitation sending autonomously via email or a messaging application.

VERIFICATION AND TROUBLESHOOTING

After sharing the Excel file, it is important to verify that the sharing works correctly and to solve any problems that may arise.

How to Test if It Works

• Verify file access: Ask collaborators to open the shared link and verify that they can access the file. If access is restricted to specific people, make sure they have logged in with their Microsoft account.
• Check real-time changes: Open the Excel file on your device and verify that the changes made by collaborators are visible immediately. Each user should see an icon with the initials of other users who are working on the file.
• Test synchronization: Modify a cell or a data range and verify that the change is visible to other users in real-time.

What to Do if It Fails

• Access issues: If collaborators cannot access the file, verify that the shared link is correct and that there are no access restrictions. Make sure users have logged in with their Microsoft account.
• Changes not visible: If changes are not visible in real-time, check that AutoSave is enabled and that the file is saved on OneDrive. Also, verify that all users have a stable Internet connection.
• Non-functional sharing: If sharing does not work as expected, try restarting Excel and OneDrive. If the problem persists, consider using another platform or alternative app for file sharing.

You have learned how to share an Excel file collaboratively, leveraging the built-in software features and alternative platforms. Now you are ready to put these skills into practice to optimize teamwork and improve productivity.

• Follow the detailed steps to share the file on OneDrive, on a network, or via specific apps.
• Choose the sharing mode most suitable for your needs: collaborative or read-only.
• Send the sharing links to your colleagues and start working together efficiently.

Happy work and collaboration!