How to cancel a shared workbook?
When you receive a shared workbook, some normal feature in Excel may not work, to make the workbook work successfully, you should cancel the shared workbook first as following screenshot shown. In this article, I will talk about how to quickly unshare a workbook.
Recommended Productivity Tools for Excel
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 71% of your time and solve 82% Excel problems for you. 300+ advanced tools designed for 1500+ work scenario, make Excel much easy and increase productivity immediately.60-day Unlimited Free Trial
To unshare a workbook, the following steps may help you, please do as this:
1. Open the workbook that you want to unshare, and then click Review > Share Workbook, see screenshot:
2. In the b dialog box, uncheck the Allow changes by more than one user at the same time option under the Editing tab, see screenshot:
3. Then click OK button, and in the prompt warning box, click Yes button, see screenshot:
4. And then the shared workbook is canceled at once.