[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

writeprotected excel documents

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

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

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

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
Manually copying shapes and their assigned macros one by one to a new location can be tedious, but if you use the Excel utility workbook attached to this article, the process will be much quicker and easier.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
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…

612 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