Solved

Shared file locking on SBS2008

Posted on 2010-11-10
6
1,288 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
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 Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

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…
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.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

729 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