Click Review > Share Workbook. On the Editing tab, select the Allow changes by more than one user … check box. On the Advanced tab, select the options that you want to use for tracking and updating changes, and then click OK.
The conventional way to check links in Excel is by using the Edit Links feature: Data tab > Queries & Connections group > Edit Links. This will display the following information: Source – the name of the linked file. Type – the link type: a workbook or worksheet.
You can turn off sharing by following these steps:
- Display the Review tab of the ribbon.
- Click the Share Workbook tool, in the Changes group. Excel displays the Share Workbook dialog box.
- Clear the Allow Changes check box.
- Click on OK.
By sharing an Excel file, you are giving other users access to the same document and allow them to make edits simultaneously, which saves you the trouble of keeping track of multiple versions.
Break a link
- On the Data tab, in the Connections group, click Edit Links. Note: The Edit Links command is unavailable if your file does not contain linked information.
- In the Source list, click the link that you want to break. …
- Click Break Link.
- Click Options >>
- Within: Workbook.
- Look in: Formulas.
- Find What: Type your sheetname here.
By sharing a workbook: A team can work simeltaneously on the same workbook. No multiple copies , all the data by everyone is in a single workbook. Can be used to collect information for surveys etc.