Excel Files Show 'Locked For Editing' when hosted on SharePoint, accessed via a mapped network drive, and a crash happens. (Temp files?) : locked, excel, editing, sharepoint, file

May 11, 2008 03:17pm pdt

1. Robbie_L... 207,468
2. tedbilly 172,750
3. zephyr_hex 138,853
4. moss_guru 86,100
5. NBSO_ISS 78,110
6. liebrand 77,519
7. adaco 72,100
8. clayfox 64,230
9. cobrachen 63,510
10. DaleHarris 54,530
11. ApexCo 53,135
12. TechSoEasy 39,425
13. Addihul 26,475
14. Pillalam... 25,875
15. bhanukir7 23,350

1. Robbie_L... 527,773
2. TechSoEasy 402,287
3. tedbilly 380,970
4. cobrachen 289,630
5. _TAD_ 268,809
6. zephyr_hex 237,928
7. kg_bang 218,781
8. TimHumph... 185,545
9. cjones_mcse 181,863
10. liebrand 162,908
11. andrei_t... 119,212
12. bhagavan... 114,739
13. moss_guru 112,650
14. shailaja... 95,582
15. NBSO_ISS 85,870

03.16.2007 at 09:09PM PDT, ID: 22455350

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

6.0

Excel Files Show 'Locked For Editing' when hosted on SharePoint, accessed via a mapped network drive, and a crash happens. (Temp files?)

Zones: Microsoft Sharepoint, Microsoft Excel Spreadsheet Software, SBS Small Business Server

Tags: locked, excel, editing, sharepoint, file

Excel Files Show 'Locked For Editing' when hosted on SharePoint, accessed via a mapped network drive, and a crash happens. (Temp files?)

The issue is: We use SharePoint to hold 'all data', yet some users prefer mapped drive access. 'Net Use' command is able to map SharePoint folders to drives, and overall this will work fine using either mapped drive letter access, or SharePoint http access. The problem is: If one of these Excel files is open and Excel freezes, or the PC is shut off, trying to re-open them shows they are locked for editing. Deleting temp files from users temp directory and windows temp directory does not (seem) to work. (This may be incorrect - open to suggestion.) The server, SBS2003, does not show these files as open, on anothter terminal this error is not generated.

Start your free trial to view this solution

Question Stats

Zone: OS

Question Asked By: iri-it

Solution Provided By: TechSoEasy

Participating Experts: 3

Solution Grade: A

Translate:

Loading Advertisement...

Microsoft

Internet Protocols
Applications

Development
OS

Hardware
Windows Security

Apple

Operating Systems
Hardware

Programming
Networking

Software

Internet

Search Engines
File Sharing
WebTrends / Stats
Spy / Ad Blockers

Web Browsers
New Net Users
Web Development
Chat / IM

Anti Spam
Web Servers
Anti-Virus
Email Clients

Gamers

Tips
Online / MMORPG
Puzzle
Emulators

Action / Adventure
Role Playing
Consoles
Game Programming

Strategy
Sports
Misc
Computer Games

Digital Living

Hardware
New Net Users
New Users

Software
Digital Music
Gaming World

Home Security
Apple
Networking Hardware

Virus & Spyware

Vulnerabilities
IDS
Encryption
Anti-Virus

Operating Systems Security
Software Firewalls
WebApplications
Cell Phones

Operating Systems
Internet
Hardware Firewalls

Hardware

Handhelds / PDAs
Displays / Monitors
Components
Networking Hardware

Peripherals
Laptops/Notebooks
Storage
Servers

Desktops
New Users
Misc
Apple

Software

System Utilities
Industry Specific
Network Management
Photos / Graphics
Page Layout
VMWare
Misc
Web Development

OS
CYGWIN
Voice Recognition
Message Queue
Quality Assurance
Security
Firewalls
MultiMedia Applications

Development
Database
Office / Productivity
Business Management
OS/2 Apps
Server Software
Internet / Email

ITPro

OS
Storage
Encryption
Operating Systems Security
Apple Hardware
Laptops & Notebooks
Servers
Networking Hardware
Peripherals

Devices
Displays / Monitors
WebTrends / Stats
Search Engines
Firewalls
WebApplications
IDS
Vulnerabilities
Email Clients

File Sharing
Spy / Ad Blockers
Web Browsers
Web Servers
Networking
Anti-Virus
Chat / IM
Anti Spam

Developer

Web Servers
Web Browsers
Game Programming
Dev Tools
Industry Specific
Office / Productivity

Database
CYGWIN
Web Development
Search Engines
File Sharing
WebTrends / Stats

Programming
Content Management
Application Servers
Protocols

Storage

Removable Backup Media
Storage Technology
Servers

Grid
Remote Access
Backup / Restore

Misc
Hard Drives

Miscellaneous
Security
Development
Linux
VMWare

MainFrame OS
Unix
Apple
OS / 2
AS / 400

BeOS
Microsoft
VMS / OpenVMS

Database

Oracle
Miscellaneous
MySQL
Software
Sybase
Contact Management
PostgreSQL
Data Manipulation
Clarion
InterSystems Cache

Siebel
MUMPS
OLAP
SQLBase
SAS
GIS & GPS
4GL
Berkeley DB
DB2
Informix

Interbase / Firebird
FoxPro
Reporting
LDAP
Filemaker Pro
MS SQL Server
dBase
MS Access

Security

Misc
Web Browsers
Software Firewalls
Operating Systems Security
File Sharing

Spy / Ad Blockers
Vulnerabilities
WebApplications
IDS
Anti-Virus

Encryption
Anti Spam
Email Clients
VPN
Chat / IM

Programming

Editors IDEs
Installation
Handhelds / PDAs
Multimedia Programming
System / Kernel

Algorithms
Game
Signal Processing
Project Management
Open Source

Database
Misc
Languages
Processor Platforms
Theory

Web Development

Scripting
Blogs
Web Servers
Software
Search Engines
Web Graphics
Images

Internet Marketing
Images and Photos
Components
Document Imaging
Web Languages/Standards
Illustration
WebApplications

Fonts
WebTrends / Stats
Authoring
Digital Camera Software
Miscellaneous

Networking

Protocols
Apple Networking
Network Management
Message Queue
Application Servers
Content Management
File Servers
Email Servers
Misc
Java Editors & IDEs

Wireless
Networking Hardware
Backup / Restore
System Utilities
ISPs & Hosting
Web Servers
Storage Technology
Removable Backup Media
Servers
Broadband

Grid
OS / 2
Novell Netware
Unix Networking
Windows Networking
Security
Telecommunications
Operating Systems
Linux Networking

Other

Community Advisor
Lounge
Community Support
New Net Users

Philosophy / Religion
Math / Science
Miscellaneous
URLs

Expert Lounge
Politics
Puzzles / Riddles

Community Support

Suggestions
New to EE
New Topics
Community Advisor

CleanUp
Announcements
General

Feedback
Input
EE Bugs

03.17.2007 at 04:45AM PDT, ID: 18739883

Rank: Guru

vico1:

These files weren't intended to be openned via mapped drive (Security Reasons). The proper mapping method is via HTTP opened from explorer, Therefore sharepoint would have control of who openned what and when.

Vico1!

03.17.2007 at 11:17AM PDT, ID: 18740976

iri-it:

Sharepoint permissions still apply when using it via mapped drive letter, security isnt affected or different via this way of access.

03.17.2007 at 09:36PM PDT, ID: 18742507

Rank: Master

andrei_teodorescu:

I think that you can do nothing about it; if excel freezes or the computer crashes, the user has to reopen the file and check it in... the 'checked out' state is maintained until the user saves back the file (if the user opened it for editing w/o checking it out first), or until is checked in ...

03.17.2007 at 10:43PM PDT, ID: 18742617

iri-it:

in this case, the user is not using check in/check out, but rather opening the files via mapped drive letter. based on your comment though I will have the user try to use the http interface to check out/check in and see if that fixes it. if so i will award points. (hopefully its a while before their Excel crashes again, so if anyone has 'the concrete solution' please voice it!)

03.17.2007 at 10:49PM PDT, ID: 18742625

iri-it:

dang, just noticed I put "Exchange" instead of "Excel" in the tile... Sorry about that. In the description I used the correct wording. Once I figure out how to change that I will.

*** Title Edited *** TechSoEasy -- EE's Microsoft Zone Advisor

03.18.2007 at 07:03AM PDT, ID: 18743307

Rank: Guru

vico1:

I told you Sharepoint Database keeps tracks of Who open what and when, that's why a mapped drive the way you do it will not work.

03.18.2007 at 11:26AM PDT, ID: 18744092

iri-it:

then why am I able to open it, via mapped drive, on another PC and it dosent yield this error? If what you are saying was correct then I should get the 'locked for editing' on the other computer, but dont.

I've seen this propblem answered (on Google) without SharePoint in the equation, and the solution was local temp files. I tried deleting local temp files in C:\Doc and Setting\user... and also C:windows\temp but in this case it did not clear up the error. Not 100% of the temp files were deleted, so I will focus on that as a possiblity.

03.19.2007 at 07:47AM PDT, ID: 18748404

Rank: Genius

TechSoEasy:

A mapped drive to a SharePoint library is really just an HTTP shortcut... so Vico1, you aren't really right about what you're saying. It's no different than you just entering http://companyweb/General%20Documents/file.xls (for example).

However the Check-out, Check-in info is correct. You can see this explained in http://support.microsoft.com/kb/899709. And although that KB article states that it's a 10-minute time-out. If Office crashes while editing the document, I don't think the time-out applies... you will need to go back and manually Check-in the document.

Jeff
TechSoEasy

03.19.2007 at 09:16PM PDT, ID: 18754069

iri-it:

I have advised the user to try this, but if this were indeed the cause of the problem - why would I be able to open the files on other PCs without the error?

03.20.2007 at 02:35PM PDT, ID: 18760064

iri-it:

user reported this was not the solution

03.21.2007 at 06:03AM PDT, ID: 18763460

Rank: Master

andrei_teodorescu:

you can't do nothing from the client side ... the checked-out state is maintained on the server ... in the sharepoint content database ...

anyway there are 2 types of locks. details here: http://glorix.blogspot.com/2006/09/sharepoint-2003-unlocking-longterm.html

for the short term check out, MS recommend to wait about 10 minutes: http://support.microsoft.com/kb/899709
also, have a look on this kb, too: http://support.microsoft.com/kb/884050

03.21.2007 at 08:09AM PDT, ID: 18764452

iri-it:

well, i will see if i can contact some of the posters on some of those links. from what i can tell, though, this continues to not be the solution, for the following reasons:
-files never unlocked even after an hour of waiting
-files can instantly be opened without error on another PC

so, i feel like its a temp file on the local PC issue, but that the temp files for this access are not stored in the "usual place" that they would be if you had this error w/o SharePoint.

again, "they say" if this happens using "regular Excel" then you delete C:\Doc and Setting\user\local\temp and also C:\Windows\temp. I tried that after a reboot, before opening Excel, and not 100% of the files were deleted, but most were. Error still persisted. I will try stuff like booting in to safe mode and attmepting to delete those temp files, etc..

ill report what i find, and if any of the above links leads me to another source who can answer i will award points to original poster of link for me. again though - if anyone's got the concrete answer please state it.

also, thank you all so much for the posts thus far!! :)

03.21.2007 at 02:16PM PDT, ID: 18767378

Rank: Guru

vico1:

A quick question.
If you copy the file locally and open it do you still get the same error?
Vico1!

03.21.2007 at 02:29PM PDT, ID: 18767462

iri-it:

I will ask the user to test this, and report the results. Alternativly, if I have time I will try and force a crash and test myself.

03.24.2007 at 06:24PM PDT, ID: 18786938

Rank: Genius

TechSoEasy:

You can't let a standard user check this out for you. You must be a SharePoint Administrator to check-in a document that shows a status of checked out. Please go to the SharePoint document library that contains the Excel spreadsheet and see what the status is yourself.

If it shows Checked Out, then you, as an Administrator, can force a Check-in status.

Jeff
TechSoEasy

03.27.2007 at 10:26AM PDT, ID: 18801642

iri-it:

Thanks for your assistance, TechSoEasy.

I should have elaborated when I said 'user reported this was not the solution'. When this error happens, the status does not show checked-out on SharePoint.

03.27.2007 at 10:29AM PDT, ID: 18801671

iri-it:

vico1 - I asked the user to copy the files locally and try to open, if network/sharepoint ones had error. They said yes, they were able to open them when copied locally. (Note: This was good to test, but will not be able to be a work-around due to the links in the files.)

03.27.2007 at 10:30AM PDT, ID: 18801679

iri-it:

More notes to help troubleshoot:
- User has experienced file lock problem once after reboot, but no crash. (Temp files not deleting?)

06.04.2007 at 01:36PM PDT, ID: 19211809

Venabili:

No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I will leave the following recommendation for this question in the Cleanup topic area:
Delete with points refunded

Any objections should be posted here in the next 4 days. After that time, the question will be closed.

Venabili
EE Cleanup Volunteer

06.04.2007 at 02:58PM PDT, ID: 19212518

iri-it:

You can close this question if you'd like. Its dissapointing that it never got resolved, but we are switching to SP2007 and Office 2007, so hopefully that "solves" the problem.

06.04.2007 at 08:03PM PDT, ID: 19214065

Rank: Genius

TechSoEasy:

Well... I do remember this issue... and just read back over the thread... and then I tested it on my own test network (using SBS 2003 and Windows XP Pro with Office 2003 Pro installed).

I mapped \\companyweb\General Documents as X: and then opened an Excel Spreadsheet that was in a subfolder of General Documents. It opened fine, along with the SharePoint Task Panel. Then, when I went to save it, the Save As box was, as expected, an HTML version instead of the familiar NTFS file list. The document saved just fine.

So... i wonder if on the workstation, you did not have the WebClient service running? Also, are the Office 2003 Web Components installed (the option can be selected during Office 2003 isntallation, or by rerunning Office 2003 Setup). Because these are cruicial to this in order to make it work... because essentially the document is really in http://companyweb/General%20Documents/ and if those services/components aren't installed and running, then the address won't be translated properly... mostly, it won't get the %20 in the spaces as needed to find the proper location.

Jeff
TechSoEasy

06.09.2007 at 10:36PM PDT, ID: 19251996

Computer101:

Tagged for future cleanup

Computer101
EE Admin

06.29.2007 at 03:22PM PDT, ID: 19393990

Venabili:

This question has been classified as abandoned as it has no comments in the last 21 days. I will make a recommendation to the moderators on its resolution in approximately four days. I would appreciate any comments by the experts that would help me in making a recommendation.

It is assumed that any participant not responding to this request is no longer interested in its final disposition.

If the asker does not know how to close the question, the options are here:
http://www.experts-exchange.com/help.jsp#hs5

Venabili
EE Cleanup Volunteer

08.13.2007 at 03:22PM PDT, ID: 19688083

iri-it:

TechSoEasy,

Yes, the problem is it runs fine for a while, up until a crash, and then there is no way to "unlock the files". When this happens on a normal Excel document, you can clear the temp files. In this instance, clearing the temp files dosent work.

We have stopped using SP 2003 all together, and are now on 2007. So far I have not heard a report of this problem on 2007.

08.13.2007 at 06:23PM PDT, ID: 19688737

Rank: Genius

TechSoEasy:

Well, WSS 3.0 and MOSS 2007 has much better granular permissions settings, so that doesn't surprise me. Makes it seem as though the troubleshooting was all for naught if you were planning on that upgrade anyhow.

Jeff
TechSoEasy

Accepted Solution

08.18.2007 at 01:28AM PDT, ID: 19722024

iri-it:

well, if you met the user who had the problem you would see it was not 'all for not' :-)

yes, on 2007 I see they have gone much farther with the Windows Explorer integration.

cheers!

20080236-EE-VQP-29