MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Unsharing a Workbook


Posted by Patrick on November 06, 2001 11:59 AM

I have a shared workbook on our server and am trying to remove data validation from a column. The workbook must be removed from Shared status to do this, however the "Allow changes by more than one user..." check box (which is checked) is grayed out. As a result I am unable to remove the workbook from shared status.

Any ideas of what could cause this or how to unshare the workbook?

Any assistance is greatly appreciated.


Posted by JC on November 06, 2001 12:23 PM

Check with your network admin...you may not have rights to change such things on this file.

Posted by Patrick on November 06, 2001 6:55 PM

I do not beleive that is it since I have the same file on my local C: drive and it is exhibiting the same problem.