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
Solved

File locking problem in Excel

Posted on 2014-04-24
5
379 Views
Last Modified: 2014-05-04
We have a client running Citrix Presentation Service on Windows 2003, with an Exchange 2003 and Windows 2003 File Server and Windows 2003 Application server.  

Her local workstation runs Office 2010 as does Citrix published application.  She just got a new machine at home running Windows 8.1 and maybe Office 2013 (checking this now).

She keeps getting errors that someone else (her) is in her Excel files.  & she can't toggle back and forth between Excel files.  When we login (we login in through logmein), we can't toggle back and forth and we did see a file that was locked saying she was using it.

Has anyone seen this problem.
0
Comment
Question by:lorayne912
  • 3
  • 2
5 Comments
 
LVL 15

Expert Comment

by:Ess Kay
ID: 40020806
delete the lockfile

It should be similarly named, and in the same folder as the original file (might be hidden)








Straight from Microsoft KB:    (Substitute Word for Excel)

This behaviour may occur if Word determines that the owner file for the document already exists. This may occur if one or more of the following conditions are true:

Word previously quit improperly and, therefore, did not delete the owner file. -or-
A second instance of Word is running in the background with the document already open. -or-
The document is shared over a network, and another user has it open. From my personal experience, I've found a combination of the first and third point above can recreate this error quite constantly
Temp files, left next to the original file on the network (especially if the file is large, she copy-pastes a LOT or it is open all day) are the cause.

To resolve this issue, first confirm that another user on the network does not have the document open. If the document is in use, open the document as read-only. If it is not in use, quit all instances of Word, and then remove the owner file. To do so, follow these steps.

NOTE: Because there are several versions of Microsoft Windows, the following steps may be different on your computer. If they are, see your product documentation to complete these steps.

Quit all instances of Word. To do so, follow these steps: 1. Save all your work, and then quit all programs. 2. Press CTRL+ALT+DELETE to open the Windows Security dialog box. 3. Click Task Manager, and then click the Processes tab. 4. Click Winword.exe, and then click End Process. 5. In the Task Manager Warning dialog box, click Yes. If you receive a message that states that the program is not responding, click End Now. 6. Repeat steps d and e for each occurrence of Winword.exe. 7. On the File menu, click Exit Task Manager.
Start Windows Explorer, and then browse to the folder that contains the document file that you tried to open when you received the error message.
Delete the owner file.

The owner file is located in the same folder as the document that you tried to open. The owner file name uses the following convention: It begins with a tilde (~), followed by a dollar sign ($), followed by the remainder of the document file name. The file name extension is .doc. For example, the owner file for Document.doc is named ~$cument.doc.

Start Word. If Word asks you whether you want to load the changes that were made to the Global or Normal template, click No.
Open your document.
0
 

Author Comment

by:lorayne912
ID: 40020825
I am assuming this KB applies to Excel as well.  G
0
 
LVL 15

Expert Comment

by:Ess Kay
ID: 40021025
thats why i wrote substitute word for excel in the 3rd line.
It applies to the entire line of office products
0
 

Accepted Solution

by:
lorayne912 earned 0 total points
ID: 40030655
Thanks for all of the good solutions.  The problem turned out to be that she has a new ergonomic keyboard and she accidentally got her task bar deleted.  Once we got it back, she actually was logged in multiple  times to each spread sheet.  I only figured this out because the solutions listed didn't work.

Can I accept these even though they weren't the right answer? g
0
 

Author Closing Comment

by:lorayne912
ID: 40040192
After I couldn't get it to work, I checked it out again and realized I didn't have a tool bar.   Should always try the simplest things first. g
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
It can often be challenging to stay relevant in the rapidly evolving world of technology. This can make recruiting talent difficult for companies of all sizes.
This video walks the viewer through the process of creating envelopes and labels, with multiple names and addresses. Navigate to the “Start Mail Merge” button in the Mailings tab: Follow the step-by-step process until asked to find the address doc…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …

856 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