Forum Discussion
Can't create chart, option grayed out
The trick is to uncheck the box, see screen shots.
Click Share WorkbookUncheck the box and OK
No, it is not protected. Thanks.
If you open your old workbook and Save As it into new one (.xlsx) will it be the same?
I tried that. It's the same. Thanks.
- Perhaps the workbook is in shared mode (Review tab)?
Yes, it is in "shared" mode. I'm the only user I'm sharing with. I tried to remove myself and Excel wouldn't let me. Instead, it suggested closing the file. I did that, re-opened, and it's the same. How would I make it unshare?
When I looked in help, all I found was vague video info that co-authoring is better, though it didn't bother to say how specifically it's better or even in what versions of Excel co-authoring is in. I'm using Excel as part of Office 2013, desktop version, not 365 version. I also didn't find what I was looking for, how to turn off sharing, since I'm the only one using this spreadsheet.
Thanks.
- You should be able to unshare using the button on the review tab of the ribbon.
