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 shared on J: drive. Unsharing workbook in the Review tab will allow editing.
Solution
- Open an excel file where editing options are greyed out.
- Go to the Review tab that is located in the ribbon menu.
- Click on the Unshare Workbook option.