How to Share a Worksheet in MS Excel_2690

How to Share a Worksheet in MS Excel Sharing in Excel 2003 or Earlier

Sharing workbooks in MS Excel 2003 or earlier only takes a few steps. Open the workbook you want to share and go to the Tools menu. Select Share Workbook to open the Share Workbook dialog box. Make sure you are on the Editing tab of the dialog and select the check box next to Allow changes by more than one user at the same time.

You can also go to the Advanced tab for other settings. For example, you can decide how long you want to keep a history of any changes to the workbook you are sharing, or opt not to keep such a history. In the Update Changes section, you can determine whether to cheap save changes to the workbook you are sharing whenever the Excel file is saved or automatically based on a time you select, and whether you want to view changes made by others. replacement You can also select settings for prompts when there there is conflicting data entered by another user.

When you are finished with the advanced settings, shop click OK. Excel will notify you that the workbook will be saved and ask if you want to continue. Click OK again.

Go to the File menu and select Save cheap As. Save the workbook you are sharing on a network location samsung laptop batteries, so that it is accessible to those with whom you are sharing the Excel file.

Sharing in Excel 2007

Sharing charger workbooks in Excel 2007 is quite simple, as well. Open the workbook you want to share and go to Review tab. Click on Share Workbook in the Changes group.

Go gateway to the Editing tab and select Allow Changes by More Than One User at the Same Time check box. Go to the Advanced tab and, as with Excel 2003, select any of the advanced new settings you wish to apply. When you are finished with the advanced settings, click OK. Excel will notify you that the workbook will be saved and ask if you want to continue. store Click OK again.

Click on the Office Button and select Save As. Change the file name if you want to, and be sure to save the workbook you are sharing on a compaq network location Dell Inspiron 1501 battery, so that it is accessible to those with whom you are sharing the Excel file.

Unavailable Features in Shared Workbooks

There are several features that are discount not accessible in a shared workbook Dell Inspiron 1420 battery, depending on the version of Excel you are using. For example, you may not be able to delete worksheets, create or change charts of acer aspire Pivot tables, or insert or change pictures or hyperlinks.

If the inability to use such features makes sharing Excel workbooks impractical Dell Inspiron 6000 Battery, consider using zxcsky09520 another method to share them. Read How to Save Files to Microsoft Office Live Workspace and Sharing Spreadsheets in Google Docs to learn more ways to share Excel workbooks.