sam314159
05-12-2010, 06:46 AM
I've done a good bit of Googling to see if anyone has found a solution and it seems like the problem is still around.
I found this similar thread on another forum (http://www.mrexcel.com/forum/showthread.php?t=322936) and no one has resolved it, I was hoping maybe someone here has found a decent workaround.
The problem in short is, Excel gives me a "File Locked For Editing by Me" error and forces me to open the file as 'Read Only' when I know for a fact that the file is not open. The file is on my C drive and no one else can access it.
I have checked the VBA editor and it doesn't show the file as open. I have checked my task manager and it doesnt show another instance of Excel running.
My workarounds so far have been:
a. Reboot which wastes about 10 minutes of my time.
b. Open the file as read only and save it under a different name. This sometimes means that I end up with 4 or 5 different version of the file if I am working on it for a couple of hours.
I am running Windows XP and Office 2003 SP3.
Has anyone found a workaround? Thanks guys!
I found this similar thread on another forum (http://www.mrexcel.com/forum/showthread.php?t=322936) and no one has resolved it, I was hoping maybe someone here has found a decent workaround.
The problem in short is, Excel gives me a "File Locked For Editing by Me" error and forces me to open the file as 'Read Only' when I know for a fact that the file is not open. The file is on my C drive and no one else can access it.
I have checked the VBA editor and it doesn't show the file as open. I have checked my task manager and it doesnt show another instance of Excel running.
My workarounds so far have been:
a. Reboot which wastes about 10 minutes of my time.
b. Open the file as read only and save it under a different name. This sometimes means that I end up with 4 or 5 different version of the file if I am working on it for a couple of hours.
I am running Windows XP and Office 2003 SP3.
Has anyone found a workaround? Thanks guys!