How to open a shared Excel in Excel

by

Use the instructions below to create a shared workbook, depending on which version of Excel you are using.

2007’s Microsoft Office Excel

  1. On the REVIEW tab, click.
  2. Click SHARE WORKBOOK under the group CHANGES.
  3. Click the ALLOW CHANGES BY MORE THAN ONE USER AT THE SAME TIME option on the EDITING tab. Check the THIS ALSO ALLOWS WORKBOOK MERGING box, then select OK.
  4. Select a network location for the shared workbook in the SAVE AS dialog box so that other users can access it.

Microsoft Office Excel 2003 and previous Excel versions

  1. Click Share Workbook from the Tools menu, and then select the Editing tab.
  2. After checking the box that says "ALLOW CHANGES BY MORE THAN ONE USER AT THE SAME TIME," click OK.
  3. At the prompt, save the workbook.
  4. Save the shared workbook on a network location so that other users can access it by clicking the Save As option on the File menu.

Now let’s explore the topic of how many users can edit an Excel spreadsheet simultaneously.

The Excel workbook that you and your colleagues are working on can be opened.
We refer to this as co-authoring.
When you coauthor, you can quickly—in just a few seconds—observe each other’s changes.
Additionally, the colors of other people’s selections may differ in some versions of Excel.
In Excel, if the version you’re using allows co-authoring, you can type email addresses, select SHARE in the top-right corner, and then select a cloud location.

Now let’s see how to display a shared workbook in an Excel document.

The most recent iterations of Excel 2010, 2013, and 2016 facilitate workbook sharing and collaboration.
Click the SHARE WORKBOOK button in the Changes group of the Review tab to share an Excel workbook.
Choose the ALLOW CHANGES BY MORE THAN ONE USER AT THE SAME TIME option in the Share Workbook dialog box.
To make the Excel file accessible to others, save it to a network location.
The workbook’s name will have the word [Shared] to the right of it to show that it is shared.
Go to the Share Workbook dialog box and uncheck the ALLOW CHANGES BY MORE THAN ONE USER AT THE SAME TIME option to stop sharing the workbook.

Together, let’s see how to open two Excel spreadsheets.

  1. Click NEW WINDOW under the WINDOW group on the VIEW tab.
  2. Click VIEW SIDE BY SIDE under the WINDOW group on the VIEW tab.
  3. Click the worksheets you wish to compare in the workbook window.
  4. In the WINDOW group on the VIEW tab, select SYNCHRONOUS SCROLLING to scroll both worksheets simultaneously.
  5. You can click RESET WINDOW POSITION to go back to the initial settings after resizing the workbook windows for better viewing.
  6. To compare the worksheets, open the two workbooks that contain them.
  7. To compare a sheet, click on it within each workbook window.