Features not available in Shared Excel Workbooks

Modified on Thu, 12 Oct, 2017 at 3:16 PM

Features a shared workbook does not support

A shared workbook doesn't support all the features in Excel. If you want to include any of the following features, add them before you save the workbook as a shared workbook. You cannot make changes to these features after you share the workbook.

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
Sort or filter by formatting	You can sort or filter by number, text, or date, apply built-in filters, and filter by using the Search box
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
Use the Text to Columns command
Group or outline data	You can use existing outlines
Insert automatic subtotals	You can view existing subtotals
Create data 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
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
Use a data form to add new data	You can use a data form to find a record