[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

The File is locked for Editing

Posted on 2013-06-14
7
Medium Priority
?
2,590 Views
Last Modified: 2013-06-18
I am having an issue accessing Excel documents  saved on a Network drive, located on a Small Business Server 2011. Documents are created in Office 2010 on Windows 7 machines. The problem is accessing the Documents from Mac's running Office 2011 v14.3.5, which I just updated to try to resolve the problem. The problem is random, does not happen on all documents all the time. The work around has been to go to the machine that has reportedly locked the file, do a "save as" as a different name, delete the original and then all machines can access for a period of time.

Here are some steps I have taken from posts I have read regarding this issue;
-Change Owner of the shared folder to Domain\User full control
-Use the Open and repair tool from within Excel
-Run a Compatibility check from Excel 2011 Mac, which returns a report stating "Workbook     contains features not available in earlier versions of Excel"

Recent workaround, I saved as Excel 97-2003 Workbook, seems to be working for time being.

Please advise if anyone else has experienced this and have found a solution.
0
Comment
Question by:slimjim1437
[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
  • 4
  • 3
7 Comments
 
LVL 13

Accepted Solution

by:
Xaelian earned 1000 total points
ID: 39248940
It's an issue that some other mixed environments encounter. The problem is that there is a hidden file created when editing the excel sheet.
When you close the excel sheet this hidden files wasn't deleted on the networkdrive. Windows computers can still open it without problems but Mac's can't.
You can go to the folder and delete the hidden file, starts with $filename. You have to do this on a Windows computer, because on Mac you won't be able to see this.
0
 

Author Comment

by:slimjim1437
ID: 39251843
Is there a way to have the Server delete the temp file when closing?
0
 
LVL 13

Expert Comment

by:Xaelian
ID: 39251846
No, because the SBS won't know when it's closed. But you can create a script that deletes these files every day or so.
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
LVL 13

Expert Comment

by:Xaelian
ID: 39251849
Or every hour. When the file is being edit you can't delete the file.
0
 

Author Comment

by:slimjim1437
ID: 39251857
I do not know how to write a script. The Network shared folder is quite large, 200 GB. Would a script be able to check whole shared drive for temp's and delete?
0
 
LVL 13

Expert Comment

by:Xaelian
ID: 39251867
Well it can do it. But that would take some time. I can only say this for the script: DEL //share/*.tmp but you need something that will go into some subtrees.
Maybe someone of the Windows scriptkiddies has some sort of script.
0
 

Author Closing Comment

by:slimjim1437
ID: 39258270
It seems like a reasonable explanation but does not resolve my issue.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…
Cancel future meetings from user mailboxes in Office 365 using Remove-CalendarEvents
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

649 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