Solved

Shared file locking on SBS2008

Posted on 2010-11-10
6
1,280 Views
Last Modified: 2012-05-10
We have an issue that intermittantly when a user opens an Excel file another user already has open it is not flaged as "locked for editing" and allows the user to open it as well.

I have tried to find a pattern but it seems random but frequent.

Has anyone any ideas?
0
Comment
Question by:esitrepxe
  • 2
  • 2
6 Comments
 
LVL 4

Expert Comment

by:Nathan-B2B
ID: 34107260
Had this issue just the other day actually.

Believe it or not it is the details pane in windows explorer that was causing the issue for us.

Ie when you open up a folder in windows explorer, then click an excel spreadsheet once (to highlight it), at the bottom of the windows exploerer window, it would display details of the file at the bottom of the window.

This caused the file to be locked for editing by anyone else trying to access the file.

To fix it we applied a domain policy.

Group Policy Management Editor
User Config -> Admin Templates -> Windows Components -> Windows Explorer -> Explorer Frame Pane.

Turn off Details Pane - Enabled
Turn off Preview Pane - Enabled.

This fixed it for us.

Good luck.
0
 

Author Comment

by:esitrepxe
ID: 34109974
HI Nathan

I don't think we have the same problem. My problem is that one user can have an Excel doc open and be
working on it. Then another users can open it & start working on it. Instead of getting the message that
the doc was locked for editing & giving them the option to open it in read only mode.

Cheers,

Stu
0
 
LVL 4

Accepted Solution

by:
Nathan-B2B earned 500 total points
ID: 34115577
Sorry about that Stu,

Excel does have the ability to allow multiple access to the same file.

It depends whether the workbook has been setup to be shared.

Under Office 2007, go to the review tab and then click "share workbook".

This will then allow the excel spreadsheet to be accessed by multiple people.

You can tell if this has already been done by looking at the title bar, it should have [shared] in there if it has been setup already.

This may be the cause.
0
 

Author Comment

by:esitrepxe
ID: 34393935
the issue was to do with DFS file repilication .

we removed that & its been ok since
0
 
LVL 50

Expert Comment

by:teylyn
ID: 34415215
This question has been classified as abandoned and is being closed as part of the Cleanup Program.  See my comment at the end of the question for more details.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Outlook Free & Paid Tools
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…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

708 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now