In a shared workbook, you cannot: | However, this functionality is available: |
| Create an Excel table | |
| Insert or delete blocks of cells | You can insert entire rows and columns |
| Delete worksheets | |
| Merge cells or split merged cells | |
| Add or change conditional formats | You can use existing conditional formats as cell values change |
| Add or change data validation | You can use data validation when you type new values |
| Create or change charts or PivotChart reports | You can view existing charts and reports |
| Insert or change pictures or other objects | You can view existing pictures and objects |
| Insert or change hyperlinks | You can use existing hyperlinks |
| Use drawing tools | You can view existing drawings and graphics |
| Assign, change, or remove passwords | You can use existing passwords |
| Protect or unprotect worksheets or the workbook | You can use existing protection |
| Create, change, or view scenarios | |
| Group or outline data | You can use existing outlines |
| Insert automatic subtotals | You can view existing subtotals |
| Create data tables (data table: A range of cells that shows the results of substituting different values in one or more formulas. There are two types of data tables: one-input tables and two-input tables.) | You can view existing data tables |
| Create or change PivotTable reports | You can view existing reports |
| Create or apply slicers | Existing slicers in a workbook are visible after the workbook is shared, but they cannot be changed for standalone slicers or be reapplied to PivotTable data or Cube functions. Any filtering that was applied for the slicer remains intact, whether the slicer is standalone or is used by PivotTable data or Cube functions in the shared workbook. |
| Create or modify sparklines | Existing sparklines in a workbook are displayed after the workbook is shared, and will change to reflect updated data. However, you cannot create new sparklines, change their data source, or modify their properties. |
| Write, record, change, view, or assign macros | You can run existing macros that don't access unavailable features. You can also record shared workbook operations into a macro stored in another nonshared workbook. |
| Add or change Microsoft Excel 4 dialog sheets | |
| Change or delete array formulas | Excel will calculate existing array formulas correctly |
| Use a data form to add new data | You can use a data form to find a record |
| Work with XML data, including: | |
| Import, refresh, and export XML data | |
| Add, rename, or delete XML maps | |
| Map cells to XML elements | |
| Use the XML Source task pane, XML toolbar, or XML commands on the Data menu | |
