Opening a Shared Workbook

You open a shared workbook just as you would any workbook in Excel. Click the Open button on the Standard toolbar. Excel opens the shared workbook.

To remove a workbook from shared use, choose Tools, Share Workbook. Click the Allow Changes by More Than One User at a Time check box. This setting should clear the Allow Changes by More Than One User at a Time check box. Click OK. Excel prompts you to confirm removing the workbook from shared use. Click Yes. After you remove the file from the shared list, Excel removes the History sheet from the workbook. The History sheet contains a history of the changes made for the number ...

Get Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.