tech on the net
Home About Us Feedback Site Map

Microsoft

Access Excel Word

Database

SQL Oracle / PLSQL SQL Server MySQL MariaDB PostgreSQL

Web Development

HTML CSS Color Picker

Language

C Language

More

ASCII Table Linux UNIX Java Clipart Joke of the Moment
Share this page:

MS Excel: Share a spreadsheet between multiple users in Excel 2003/XP/2000/97

Question: In Microsoft Excel 2003/XP/2000/97, how can I have one spreadsheet shared by many users? We want to all be in the same document at the same time saving changes.

Answer: To share an Excel spreadsheet, select Share Workbook under the Tools menu.

Microsoft Excel

When the Share Workbook window appears, click on the checkbox to allow changes by more than one user at the same time.

Microsoft Excel

Click on the Advanced tab. You can then customize the options. Click on the OK button.

Microsoft Excel

The following message should appear. Click on the OK button.

Microsoft Excel

Now when you return to the spreadsheet, you should see [Shared] at the end of the file name. This indicates that the Excel file is set up as a shared workbook.

Microsoft Excel