Share Excel File for Multiple Users in Office 365: No OneDrive Needed

Sharing Excel files in Office 365 can be a breeze, even without using OneDrive. If you're looking to collaborate with multiple users, there are several methods to achieve this seamlessly. Let's explore how you can share your Excel files without relying on OneDrive.

Combine Multiple Excel Files into One
Combine Multiple Excel Files into One

Before we dive into the methods, it's crucial to understand that Office 365 offers several sharing options, including sharing directly from the app, using SharePoint, or via email. Each method caters to different needs, so let's explore them in detail.

How to merge multiple excel files into one workbook?
How to merge multiple excel files into one workbook?

Sharing Directly from the Excel App

The Excel app in Office 365 provides an easy way to share files with others. This method is ideal for quick, one-time sharing.

5 Places to Access “Shared with Me” Documents in Office 365
5 Places to Access “Shared with Me” Documents in Office 365

To share your Excel file directly from the app, follow these steps:

Sharing with Specific People

the text combine excel files and add multiple file types into one column with arrows pointing to them
the text combine excel files and add multiple file types into one column with arrows pointing to them

1. Open your Excel file in the Office 365 app.

2. Click on the 'Share' button in the top-right corner.

3. Type the email addresses of the people you want to share the file with.

Combining multiple excel files into one location📚
Combining multiple excel files into one location📚

4. Choose the level of access (view, edit, or present) and click 'Apply'.

Sharing via a Link

1. Open your Excel file in the Office 365 app.

Combine Data from Multiple Excel Files in a Single Excel Sheet - Part 1
Combine Data from Multiple Excel Files in a Single Excel Sheet - Part 1

2. Click on the 'Share' button in the top-right corner.

3. Click on 'Anyone with the link' to generate a shareable link.

How to Merge Microsoft Excel Files and Sheets
How to Merge Microsoft Excel Files and Sheets
How to Link Excel Data Across Multiple Sheets (7 Easy Ways)
How to Link Excel Data Across Multiple Sheets (7 Easy Ways)
Excel Functions Cheat Sheet | 50+ Essential Formulas Every Beginner Should Know
Excel Functions Cheat Sheet | 50+ Essential Formulas Every Beginner Should Know
100+ Ready Made Excel Templates
100+ Ready Made Excel Templates
Split the difference ✂️ Now rollled out in #Excel for Office 365
Split the difference ✂️ Now rollled out in #Excel for Office 365
the advanced excel chart sheet is shown in green and has instructions on how to use it
the advanced excel chart sheet is shown in green and has instructions on how to use it
the excel shortcuts list is shown in red and green, with numbers on each side
the excel shortcuts list is shown in red and green, with numbers on each side
The 5 Best Websites to Download Free Excel Templates
The 5 Best Websites to Download Free Excel Templates
How to Combine Sheets in Excel (6 Easiest Ways)
How to Combine Sheets in Excel (6 Easiest Ways)
How To View Two Sheets Side-by-side In The Same Excel File
How To View Two Sheets Side-by-side In The Same Excel File
Make a Clickable Directory with Excel – Easy Navigation Hack
Make a Clickable Directory with Excel – Easy Navigation Hack
Downloadable guides to master Office 365
Downloadable guides to master Office 365
The Master List of Microsoft Excel Formulas!
The Master List of Microsoft Excel Formulas!
🧮 Quick Excel Wizardry
🧮 Quick Excel Wizardry
How to separate information on Excel
How to separate information on Excel
Microsoft Excel Cheat Sheet | Essential Formulas, Shortcuts & Productivity Tips
Microsoft Excel Cheat Sheet | Essential Formulas, Shortcuts & Productivity Tips
the 5 excel shortcuts i use in daily reporting work smarter save time more
the 5 excel shortcuts i use in daily reporting work smarter save time more
The 10 Best Excel Alternatives for Your Spreadsheet Needs
The 10 Best Excel Alternatives for Your Spreadsheet Needs
Excel Helpful information .... 👍🏻👍🏻💱
Excel Helpful information .... 👍🏻👍🏻💱
Top 101 Excel Templates for Productivity
Top 101 Excel Templates for Productivity

4. Choose the level of access (view, edit, or present) and click 'Apply'.

Sharing via SharePoint

SharePoint is a powerful collaboration platform that integrates seamlessly with Office 365. It's an excellent choice for teams that need to collaborate on files regularly.

To share your Excel file via SharePoint, follow these steps:

Uploading and Sharing the File

1. Navigate to your SharePoint site.

2. Click on 'Upload' and select the Excel file you want to share.

3. Once uploaded, click on the file to open it in the Excel app.

4. Follow the same sharing steps as mentioned earlier (Sharing with Specific People or Sharing via a Link).

Setting Permissions for the Library

1. Navigate to your SharePoint site and click on the gear icon in the top-right corner.

2. Select 'Site settings' and then 'Site permissions'.

3. Here, you can set permissions for the entire library, allowing or restricting access to specific groups or users.

By using these methods, you can effectively share your Excel files with multiple users in Office 365 without relying on OneDrive. Each method caters to different needs, so choose the one that best fits your collaboration requirements. Happy sharing!