how to make an excel spreadsheet shared office 365

How to Make an Excel Spreadsheet Shared in Office 365

In today's digital age, collaboration is key to achieving success in any organization. One of the most popular tools for sharing and collaborating on spreadsheets is Microsoft Excel, especially when paired with Office 365. In this article, we will explore how to make an Excel spreadsheet shared between two workbooks stored in OneDrive for Business.

Step-by-Step Guide

To begin, repeat steps 1 to 4 to open your second Excel workbook in your desktop version of Excel. Your desktop version of Excel should now display your first Excel workbook. Next, click on the three dots (ellipsis) to the right of the file name to reveal additional menu options. Navigate to the folder/directory containing your first Excel workbook.

Log in to your Office 365 account and open OneDrive. To link a Destination cell to a Source cell in two Excel workbooks in OneDrive, follow these steps:

1. Open both Excel workbooks in OneDrive.

2. Select the cell you want to link as the Destination cell.

3. Go to the 'Data' tab and click on 'From Other Sources.'

4. Select 'From Microsoft Query' and then 'Edit Query.'

5. In the 'Microsoft Query' window, select the Source workbook and specify the cell range you want to link to.

6. Click 'OK' to create the link.

Benefits of Linking Excel Workbooks in OneDrive

Linking cell references in two Excel workbooks ensures that links function correctly regardless of which machine the two OneDrive files are subsequently opened on. This means that if data is updated in the Source workbook, the linked cell in the Destination workbook will reflect the change.

Additionally, when two Excel workbooks are linked, selected cell data in the Source workbook appears in referenced cells in the Destination workbook. This makes it easy to collaborate with others and keep track of changes made to your spreadsheets.

In conclusion, making an Excel spreadsheet shared between two workbooks stored in OneDrive for Business is a simple process that can be completed in just a few steps. By following this guide, you will be able to create links between your workbooks and collaborate with others more effectively. Whether you are working on a project or simply need to share data with colleagues, linking Excel workbooks in OneDrive is an essential skill to have.

How to make an excel spreadsheet shared office 365