There is a computer in one of our offices that is having a ton of issues using excel on a network location.

The computer is running Windows 7 with Office 2013.

Anytime I open a file the ~$ owner file is created but never deleted, after closing it stays until I manually remove it.

When trying to open the file sometimes it will tell me the file is in use, even if no other computer has opened it. 

Almost every time I try to save the file it will tell me it is in use, even when creating a new file after the first save I start having these problems. 

All other computers on the domain can open the file and save with no trouble.

I think it may be related to the network drive. When the file is opened or saved the progress bar for the network location tries to reload (green bar) and it never finishes.

When I am able to save the documents they seem to take a very long time to finish. Sometimes I will be able to save a change, and even without closing the document if I try to save again it says it is in use.

I tested different locations and different files, including making new files and anything on the network drive has the same issue. When saving locally to the computer there are no problems at all.

The method of closing the open file from the server management did not help either.

Hi Jchilson,

Based on your description, you said the user cant delete the ~$ file automatically. And you always get the message said File in use. This issue appeared in all files in network, but worked fine in local computer. And other users didnt have this issue.

Now I suppose this issue might be caused by permission of this users account in network. It seems that the permission of this user is only read. When he opens the shared file, the document creates a temp file (~$ file is the temp file) in the same directory as the original file. Thus the document gets a temporary lock file. He have no permission of deleting or overwriting temp file in network, so when he open or save the shared file he get the error message said File in use.

Please check the permission of this users account, if its different from other users accounts in network, and modify it.

Trying this method and let me know if it works. I am glad to help and forward to your reply.

Best Regards,

I have checked permissions and that doesn't appear to be the issue. All users on our domain have read / write on everything on this network share. 

To be safe I added the specific user and gave full control but the problems are still the same.

Thank you for the suggestion and any other ideas are welcome.