Você deve verificar a lista abaixo. Pelo menos um dos itens não suportados deve ser o culpado.
De support.office.com :
Shared Workbooks have limitations, and therefore we highly recommend co-authoring, which is the replacement for Shared Workbooks.
Please be aware that Shared Workbooks is an older method of sharing. Therefore, many items and actions are not supported when this method is used. The table below is only a partial list of features not supported.
Unsupported items:
- Creating or inserting tables
- Adding or changing conditional formats
- Adding or changing data validation
- Creating or changing charts or PivotChart reports
- Inserting or changing pictures or other objects
- Inserting or changing hyperlinks
- Creating, changing, or viewing scenarios
- Inserting automatic subtotals
- Creating data tables
- Creating or changing PivotTable reports
- Creating or applying slicers
- Creating or modifying sparklines
- Adding or changing Microsoft Excel 4 dialog sheets
- Importing, refreshing, and exporting XML data
Unsupported actions:
- Inserting or deleting blocks of cells
- Deleting worksheets
- Merging cells or splitting merged cells
- Sorting or filtering by format
- Using drawing tools
- Assigning, changing, or removing passwords
- Protecting or unprotecting worksheets or the workbook
- Grouping or outlining data
- Writing, recording, changing, viewing, or assigning macros
- Changing or deleting array formulas
- Adding, renaming, or deleting XML maps
- Mapping cells to XML elements
- Using the XML Source task pane, XML toolbar, or XML commands on the Data menu
- Using a data form to add new data