?
Solved

writeprotected excel documents

Posted on 2012-04-10
2
Medium Priority
?
252 Views
Last Modified: 2012-06-27
When my users open excel documents from the servers share they recive a messege that this doucumnet is opened by a other user you can oen this document in read mode.
You can also notify user about this.

When notifying the user is pressed it takes about 10 seconds the the document i read and write.

The problem is that there is no other user who has this document opened.
I belive that this started when we started to use Office 2010.

Can anyone help me with this problem ? Why do users get this messeges ?
0
Comment
Question by:cfajilu
2 Comments
 

Accepted Solution

by:
TPCM earned 1500 total points
ID: 37829250
Hi cfajilu

You might want to try removing the 'share' permissions from the spreadsheet in question or the containing folder and then re-applying the share permissions.

Please let me know how you get on.

Regards

TPCM
0
 
LVL 2

Expert Comment

by:Peppermint
ID: 37836039
I had the same problem.  A simple fix that may or maynot be practical is to rename the file and copy to a different directory.  This worked.  

In some cases, we had to install a Microsoft Office Hotfix.
Below is more information on doing that as well as some general information on file locking\unlocking.

http://blogs.technet.com/b/the_microsoft_excel_support_team_blog/archive/2011/05/02/file-is-locked-for-editing-by-another-user.aspx

Hope this helps.
Pep
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

What to do if a split doesn't fit? Or a bunch of invoice lines must be rounded while the sum must match a total? It takes a little, but - when done - it is extremely easy to implement.
Here is why.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

590 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question