On the File menu, click Save As, and then save the shared workbook on a network location where other users can gain access to it.

Save the workbook when you are prompted.

Click to select the Allow changes by more than one user at the same time check box, and then click OK.

On the Tools menu, click Share Workbook, and then click the Editing tab.

Microsoft Office Excel 2003 and earlier versions of Excel Note: If your file is not already saved to OneDrive, youll be prompted to upload your file to OneDrive to share it.

In the Save As dialog box, save the shared workbook on a network location where other users can gain access to it.

This also allows workbook merging check box, and then click OK. If you want to publicly share your spreadsheet, click Get shareable link inside the Share with others.

On the Editing tab, click to select the Allow changes by more than one user at the same time. To keep control over who can edit the list, click Advanced in the bottom right.

Click Share Workbook in the Changes group.

To set up a shared workbook, follow these steps, as appropriate for the version of Excel that you are running. Try Sheets for Work Go to Sheets Don't have an account See what you can do with Google Sheets Collaborate on. If a workbook that was created in Excel 95 is shared, it is a read-only workbook when it is opened in Excel 97 or a later version of Excel. Create and collaborate on online spreadsheets in real-time and from any device. Specifically, even if a shared workbook that was created in Excel 97 or a later version of Excel is saved as an Excel 95 workbook, the workbook cannot be shared. To make changes to a shared workbook that was created in Microsoft Excel 97 or a later version of Excel, you must use Excel 97 or a later version of Excel. When more then one person tried to access the file, a notice pops up that someone else is in the file and it can be Read Only.

It is not possible to open shared workbooks that are created in Microsoft Excel 95 in later versions of Excel and still maintain their shared status. 1 Answer Sorted by: 1 From this post, If you want to give the permission of viewer and editor to users for the shared spreadsheet, you are required to share the endpoint like fileId /edituspsharing. But Excel is showing the workbook is 'shared' but it isn't.

How to make a spreadsheet shareable