Excel features greyed out when editing file on shared drive

Summary

In the Review tab, that can be found in the top menu of Excel, disable workbook sharing by pressing Unshare Workbook.

Body

Overview

Some editing options might be greyed out when editing excel files that are on shared drives. Unsharing workbook in the Review tab will allow editing.

Solution

  1. Open an excel file where editing options are greyed out.
  2. Go to the Review tab that is located in the ribbon menu.
  3. Click on the Unshare Workbook option.

Details

Details

Article ID: 3494
Created
Fri 4/8/22 5:09 PM
Modified
Tue 11/18/25 11:22 AM
Environment
Enter the environment(s) in which this article is relevant. Eg. software name and specific version, OS(s), model of hardware, location, etc.
Excel
Windows
Office 365
Shared Drives