[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Annoying message "Excel file is currently in use..."

Posted on 2014-08-08
23
Medium Priority
?
2,805 Views
Last Modified: 2016-11-23
Hello,

Recently in the last couple of months I've been getting an annoying pop up whenever I am working with XLSX files. The XLSX files are stored on the LAN.

The pop up shows the following message below:

'filename.xlsx is currently in use. Try again later.

In many cases, I have to click the OK button dozens of times to get it to stop - which is very annoying.

So, I have 3 questions:

1 - When it says "... Try again later."  -  Try WHAT later?

2 - What is causing this to happen?

3 - How can I stop it or turn the message off?

Running Office 10 on Windows 8 Pro, 64bit -  Dell Precision T7600

TIA for your help.
0
Comment
Question by:pelampe
  • 11
  • 7
  • 3
  • +1
22 Comments
 
LVL 16

Expert Comment

by:Joshua Grantom
ID: 40248757
This is happening because someone else has the file open or your session is not closing properly. Do you log out at the end of the day?
0
 
LVL 23

Expert Comment

by:rhandels
ID: 40248766
Yes,

This message says that your XLSX file is currently being used by either another user (when on LAN) or another process.
So to answer your questions.

1. Try to open the file later because you can not exclusively use the file right now.
2. As said, it is in use.
3. You can't. It's build in Microsoft that gives you this error when someone else is working with the document.
0
 

Author Comment

by:pelampe
ID: 40249213
Thank you both for the prompt responses.  Below are replies to each of your comments (mine are in bold).

Also, somehow, I did not complete the process before of attaching the screen shot of the error, but have done so now.  When you open the attachment you will see a #1 and a #2.  The #1 represents that message that I am getting now that prompted me to open this case.  The #2 screen shot is intended as additional info in response to RHANDELS comments.

JOSHUA G:
This is happening because someone else has the file open or your session is not closing properly. Do you log out at the end of the day?
. I am 99% sure that no one is trying (or actually has these files opened).  As far as being logged out at the end of the day;  I normally don't log off at the end of the day because I sometimes have to remote-in to do some night time work from home.  Once I get in to the office the next day I always reboot.

RHANDELS:
1. Try to open the file later because you can not exclusively use the file right now.
2. As said, it is in use. 3. You can't. It's build in Microsoft that gives you this error when someone else is working with the document.
1) The file is already open - I am the only person who is working in it.  If you look at the attached screen shot #2 you will see what it would look like IF someone else had the file open and then I tried to open the same file 2) I am the only person who is using the file. 3) Not sure if this is applicable in this case
file-in-use-vs.-in-editing.jpg
0
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 
LVL 99

Assisted Solution

by:John Hurst
John Hurst earned 1200 total points
ID: 40249255
See if you have persistent drive mappings that may have caused additional (duplicate) drives.

Open cmd.exe and run NET USE  .  See what drives are there.  Delete them all.

NET USE  Z: /Delete for all drives.

Restart the computer and test.
0
 

Author Comment

by:pelampe
ID: 40249443
JOHN: are you saying that you want me to DISCONNECT the drive mappings?  I have 5 drive mappings that I regularly use. I don't have a problem DISCONNECTING from them, but wanted to check first.

Also, I did run the NET USE command, and it showed ALL five drive mappings STATUS as "Unavailable".  Is that normal?

When you look at them on the Explorer GUI they all look normal.
0
 
LVL 99

Assisted Solution

by:John Hurst
John Hurst earned 1200 total points
ID: 40249449
What I should have said was Disconnect All drive mappings, restart and then remap. You could have superfluous drive mappings in place not showing up in Windows Explorer but still causing issues. So delete ALL driver, restart and then map what you need. Test after that.
0
 

Author Comment

by:pelampe
ID: 40249907
ALL:  One other thing.

I would have mentioned this earlier, but thought it was a separate issue.  For some reason, I'm also encountering a strange behavior where all of sudden, Excel will start opening up multiple workbooks from the server.  In 90% of the case, they are ones that I've worked with at some point in time.  It could be 5 months though, since I've actually worked in that workbook.  Just today about an hour ago, I noticed about 25 opening up all at once.

JOHN:  I will try that DISCONNECT command next and let you know.
0
 
LVL 99

Assisted Solution

by:John Hurst
John Hurst earned 1200 total points
ID: 40249913
Excel (and other apps) use recent files. This is not necessarily related to persistent drives. So in addition to removing persistent drives, also do an Office Repair from Control Panel. This may correct Excel behaviour.
0
 

Author Comment

by:pelampe
ID: 40428583
Hi Everyone,

First off, please accept my humble apologies for not responding in a timely manner.

The issue still has not been resolved however.  The IT dept are still scratching their heads as to what is the cause of this problem.  I've done all the steps that John Hurst has recommended and still the problem is occurring.

Due to this becoming more complicated than I had originally anticipated I'm raising the points level to 500 in an attempt to provide more incentive towards solving this crazy problem.

Many THANKS to those of you who have participated and I'm looking forward to your responses.
0
 
LVL 99

Assisted Solution

by:John Hurst
John Hurst earned 1200 total points
ID: 40428642
If you can take a computer or two computers and delete ALL mappings, restart, map only what you need and then, the problem continues to occur, then:  The issue is likely the server locking files and not a workstation problem at all.
0
 

Author Comment

by:pelampe
ID: 40428887
I've opened the Event Viewer and have loaded 2 screenshots.

The first JPG is the actual window showing ALL of the popups.

The second JPG is what the DETAILS tab shows (in XML).

Please take a look at these and let me know if there's anything relevant to this issue.
office-14-event-log.jpg
office-14-event-log-details.jpg
0
 
LVL 99

Expert Comment

by:John Hurst
ID: 40428934
I wonder if the path is too long or bordering on too long.  Try the same thing with a much shorter total path.
0
 

Author Comment

by:pelampe
ID: 40428954
Sorry, but that will not be an option to take in solving this issue.

There must be someone else who has encountered this problem before.  I can't believe it's that unique of a situation.
0
 
LVL 99

Expert Comment

by:John Hurst
ID: 40428988
I don't see why you cannot at least try a shorter path (on the server).

No, I have not seen this issue myself or at any client over a period years that was not simply related to file really in use.
0
 
LVL 16

Assisted Solution

by:Joshua Grantom
Joshua Grantom earned 300 total points
ID: 40429000
Are you the only person this is happening to? Do you have any type of syncing or backup software running on the server that hosts the files?

Did you try the repair install of Microsoft Office? Are all the Office updates installed? Service Pack 2?
0
 

Author Comment

by:pelampe
ID: 40429404
John: I will try a making a shorter path, but it won't happen until Monday.

Joshua:  I know that this is occurring with one other person who uses the same Excel files that I do, but it doesn't happen as frequent to them.  There is a backup software program running all the time.  it is called Dlo Agent (by Symantec).  I don't know how to check about the syncing part.  What would you recommend?

We did try to run a repair, and no change. Then we did an uninstall, and no change.  As for the Office updates and Service Pack 2, I don't know but will check on that.
0
 

Author Comment

by:pelampe
ID: 40443759
I have an update for you both.

From Monday until just today, the pop ups have ceased completely.  I have not done any of the steps you've both suggested either.

That was until about 1 o'clock PM my time today.  I've also been in contact with our IT dept guys and they're both stumped but are trying to find a solution.

Is there anything I can tell them to look for on their side in terms of events from the first part of this week when there were no issues present on the Excel pop ups?  In other words, is there some type of "listening" log similar to the event log that they have access to?  I was thinking that since I now have an exact time and date when the recurrence of the pop ups occurred we could try to correlate the time slice with some events in the network logs.

What do you think?
0
 
LVL 99

Assisted Solution

by:John Hurst
John Hurst earned 1200 total points
ID: 40443775
Between this past Monday and now was a BIG patch Tuesday for workstations and servers. It is possible an update was affecting things.
0
 

Author Comment

by:pelampe
ID: 40443803
hmmm... interesting.  i wonder if the patch helped out with the issue, but then somehow got "over-ruled" and quit providing the necessary workings which allowed the pop ups to re-occur.  forgive my poor phrasing, but i hope you know what i mean.

i will keep you posted.  i'm supposed to meet with the IT guy on monday.
0
 

Accepted Solution

by:
pelampe earned 0 total points
ID: 40476605
It looks like the issue was related to a corrupted user profile.  Our IT person believed this to be the case.  We have renamed my user profile a week ago (today) and have been testing it to see if the issue is resolved.  So far it's not acted up in any way.

I will keep monitoring it for the rest of this week, and will let you know at the end of this week.
0
 
LVL 16

Expert Comment

by:Joshua Grantom
ID: 40476619
Thank you for updating us.
0
 

Author Closing Comment

by:pelampe
ID: 40490918
Consider the issue to be resolved.  I haven't had any more popups so it must've been due to the corrupt user profile.

Thanks to all who replied.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
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…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

873 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