Friday, December 16, 2011

How to Share an Excel 2003 Spreadsheet With Multiple Users


1. Open Excel 2003 by clicking the program's icon on your computer's desktop or by selecting the program's name on the “All Programs” menu.
2. Click “File” followed by “Open.” Navigate to the directory containing the spreadsheet you want to share with other users. Double-click the spreadsheet's file name to open the file.
3. Click “Tools” and select “Share Workbook.” The “Share Workbook” dialog box will open.
4. Click the check box next “Allow changes by more than one user at the same time.”
5. Click the “Advanced” tab, if you want to change the default settings related to sharing a spreadsheet.
6. Click “OK” to close the “Share Workbook” dialog box.
7. Click “OK” when prompted with the question “This action will now save the workbook. Do you want to continue?” The Excel 2003 spreadsheet is now shared. You will see the file name of the spreadsheet at the top of the screen and the wording “[Shared]” next to it.

Blogger news