Solved

writeprotected excel documents

Posted on 2012-04-10
2
223 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 500 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

Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

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

Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

770 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