Shared workbook can't be unshared

P

Phrank

Hi,

I've got a workbooked that I shared to a network, and now I have it at
home to work on some of the macros and conditional formatting, but I
can't unshare the workbook - the checkbox to share it is greyed out,
so I can't unselect it. Why is that, and what can I do to unshare it?
 
R

Richard Bradley

This is because the shared workbook is protected. Go to Tools/Protection/Uprotect shared workbook and then when you next try to unshare the workbook it will allow you to do so.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I UNSHARE an Excel Workbook 2
Sharing workbook error message 1
Can't UNshare a shared workbook 1
Unshare a Shared Workbook 1
Excel Shared Workbook 1
share workbook 4
Shared workbook 1
Sharing option greyed out 1

Top