Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

writeprotected excel documents

Posted on 2012-04-10
2
Medium Priority
?
244 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
Ever wonder what it's like to get hit by ransomware? "Tom" gives you all the dirty details first-hand – and conveys the hard lessons his company learned in the aftermath.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

772 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