Unshare workbook is greyed out Excel 2016??

If you are facing the issue where the “Unshare Workbook” option is greyed out in Excel 2016, it can be quite frustrating. This issue can occur due to various reasons, such as the workbook being protected, or the user not having the necessary permissions to unshare the workbook. However, there are some solutions that you can try to fix this problem:

1. Check if the workbook is protected: If the workbook is protected, you will not be able to unshare it. To check if the workbook is protected, go to the “Review” tab and see if the “Protect Workbook” option is enabled. If it is, then you need to unprotect the workbook first before you can unshare it.

2. Check if you have the necessary permissions: If you are not the owner of the workbook or do not have the necessary permissions, you will not be able to unshare it. In this case, you need to contact the owner of the workbook and ask them to grant you the necessary permissions.

3. Save the workbook as a new file: If none of the above solutions work, you can try saving the workbook as a new file. To do this, go to “File” > “Save As” and choose a new name and location for the file. This will create a new copy of the workbook that is not shared, and you can work on it without any issues.

In conclusion, if you are facing the issue where the “Unshare Workbook” option is greyed out in Excel 2016, you can try the above solutions to fix the problem. By checking if the workbook is protected, ensuring that you have the necessary permissions, or saving the workbook as a new file, you can unshare the workbook and continue working on it without any issues.

Conclusion

I hope these solutions help you resolve the issue with the “Unshare Workbook” option being greyed out in Excel 2016. Remember to check if the workbook is protected, ensure that you have the necessary permissions, or save the workbook as a new file. If you have any further questions or concerns, feel free to ask. Good luck!

Answer Prime

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top