How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Richard Your Own Question

Richard, Software Specialist
Category: Microsoft Office
Satisfied Customers: 30206
Experience:  Over 15 year experience resolving Microsoft Office Issues
Type Your Microsoft Office Question Here...
Richard is online now
A new question is answered every 9 seconds

Many users need to acces an excel file which I cannot put in

This answer was rated:

Many users need to acces an excel file which I cannot put in shared mode because each user must use filters which creaqtes conflicts and makes the file corrupt. We therefore put it in individual mode and when someone needs to access it, they need to find which user is in it to contact them to close it.

The problem is, since we changed to the Exchange server, the username that appears is not the one of the user that is currently in the file. It gives the name of the last person that saved the document.

What do we need to do do change this. We need to be able to see who is actually in the document.
Thank you for your question, my name is Richard.

When you access the Excel file, Excel creates a hidden file on the share where the file is located, called ~$filename where filename is XXXXX XXXXX file. That hidden file conatins the name of the user who has the file locked.

Generally, this file not being delete is the problem. It can be related to changes made on the server during the Exchange install.

Manually delete this file. If you do not see it, enable hidden files view by

Clicking Start, Computer

Than Organise (Top), Folder and Search Options

Click View

Click Show Hidden Files, Folders and drives

Untick Hide Extensions for known file types

And uncheck Hide Protected Operating System Files

Click ok.

Then look for the file, delete it and then test if you still have the problem.

If you do, please let me know so I can assist you further.

Thank you
Richard and 3 other Microsoft Office Specialists are ready to help you