Article ID: 269860 - View products that this article applies to.
This article was previously published under Q269860
This step-by-step article explains how to share a Microsoft Excel workbook with other users.
If you want several users to work in the same Excel workbook simultaneously, you can save the workbook as a shared workbook. Users can then enter data, insert rows and columns, add and change formulas, and change formatting.
Note 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.
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. 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.
To set up a shared workbook, follow these steps, as appropriate for the version of Excel that you are running.
Microsoft Office Excel 2007
Microsoft Office Excel 2003 and earlier versions of Excel
For more information about how to share workbooks, click the following article numbers to view the articles in the Microsoft Knowledge Base:
(https://support.microsoft.com/kb/129276/ )You receive a "This file is locked" error message when you try to save or close a shared file
(https://support.microsoft.com/kb/212072/ )Shared workbook lists multiple users
Article ID: 269860 - Last Review: January 11, 2007 - Revision: 6.2