Excel File Sharing Problem

[sputnam]

We have a file saved on a network drive. Whenever we try to open the
fie a message comes up indicating the file's in use by Person B.
Person B is not in the file and we had that person log off and
completely shut down, yet the file still shows as being in use by
Person B. We cannot delete, rename or move the file. Any suggestions
on how to get rid of the file, rename or move the file? HELP!!

 

[BrianB]

Sometimes theold MSDOS commands work when all else fails. You do not sa
exactly what you really want to do with it. Let's say Copy to new nam
then Delete.

Click the windows 'MSDOS Command Prompt' icon.
At the prompt type as below, excluding bracketed description, followin
each line with Enter.
-----------------------------------------------------
H: (drive letter + colon)
CD FOLDERNAME\SUBFOLDERNAME (path to folder containing the file. Ful
path should now appear as the prompt).
COPY OLDFILENAME.XLS NEWFILENAME.XLS (make copy)
DEL OLDFILENAME.XLS (delete old file)
EXIT