Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Multiple simultanious exclusive access

Status
Not open for further replies.

Frankenherder

IS-IT--Management
Jun 11, 2003
405
CA
Hello, i have a spread sheet that can be opened by multiple people on multiple computers. All parties are shown as having exclusive access and the workbook is shared without the permissions for multiple edits. is there a way to repair the apparant corruption in the file?

Thanks
Matt
 
What do you mean by "shared without the permissions for multiple edits". If I Tools, Shareworkbook but untick the "allow changes by more than one user...." setting then the workbook is removed from sharing.

Assuming that is not the issue:

Are you sure that the users are seeing and opening the network copy and not an offline files version? Also that it is not read only? I would File Save As to a new file. Delete the original then rename.
If the problem, remains then I don't know what to suggest.

Gavin
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top