Editing changes not available to a shared workbook
When you share a workbook, Excel disables some of the program's editing features so they're not available when making changes to the shared spreadsheet. The following tasks are disabled in a shared workbook:
- Deleting worksheets from the workbook
- Merging cells in the worksheets of a workbook
- Applying conditional formats to the cells of the worksheets (although any conditional formats assigned before you share the workbook remain in effect)
- Setting up or applying data validation to cells of the worksheets (although all data validations restrictions and messages assigned before you share the workbook remain in effect)
- Inserting or deleting blocks of cells in a worksheet (although you can insert or delete entire columns and rows from the sheet)
- Drawing shapes and adding text boxes with the tools on the Drawing toolbar
- Assigning passwords for protecting individual worksheets or the entire workbook (although all protection and passwords assigned prior to sharing the workbook remain in effect)
- Grouping or outlining data in a worksheet
- Inserting automatic subtotals in a worksheet
- Creating data tables or pivot tables in a worksheet
- Creating, revising, or assigning macros (although you can run macros that were created in the worksheet before it was shared, provided that these macros don't perform any operations that aren't supported in a shared workbook)
