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

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.
pelampeAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Joshua GrantomSenior Systems AdministratorCommented:
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
rhandelsCommented:
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
pelampeAuthor Commented:
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
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

JohnBusiness Consultant (Owner)Commented:
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
pelampeAuthor Commented:
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
JohnBusiness Consultant (Owner)Commented:
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
pelampeAuthor Commented:
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
JohnBusiness Consultant (Owner)Commented:
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
pelampeAuthor Commented:
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
JohnBusiness Consultant (Owner)Commented:
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
pelampeAuthor Commented:
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
JohnBusiness Consultant (Owner)Commented:
I wonder if the path is too long or bordering on too long.  Try the same thing with a much shorter total path.
0
pelampeAuthor Commented:
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
JohnBusiness Consultant (Owner)Commented:
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
Joshua GrantomSenior Systems AdministratorCommented:
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
pelampeAuthor Commented:
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
pelampeAuthor Commented:
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
JohnBusiness Consultant (Owner)Commented:
Between this past Monday and now was a BIG patch Tuesday for workstations and servers. It is possible an update was affecting things.
0
pelampeAuthor Commented:
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
pelampeAuthor Commented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Joshua GrantomSenior Systems AdministratorCommented:
Thank you for updating us.
0
pelampeAuthor Commented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.