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.
What Do You Mean By Workspace In Ms Excel Word
Space used or required for one's work, as in an office or home. A workspace contains pointers to your other Excel files that you had open during your session. When you open an Excel workspace all the other files are opened as well Workspaces are particularly useful if you frequently work with the same set of files and need to have them all open at once. Set your Spreadsheet Workspace. An Excel workspace (sometimes known as an arranged workspace) is really just a special file that keeps a record of all the workbooks open at the time you save the workspace, as well as all the workbooks' screen attributes - things like window sizes and arrangement, screen magnification, and any other display settings in use at the time.
Answer: To share an Excel spreadsheet, select Share Workbook under the Tools menu.
When the Share Workbook window appears, click on the checkbox to allow changes by more than one user at the same time.
Click on the Advanced tab. You can then customize the options. Click on the OK button.
The following message should appear. Click on the OK button.
What Do You Mean By Workspace In Ms Excel Shortcut
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.