workbook thinks it is open when it is not

[widman]

I have a couple of excel workbooks that have decided (for a couple of months)
to tell me that they are in use and I can only open a "read only" version.
They are not in use. Sometimes restarting my computer releases them, but that
shouldn't be necessary.

Windows Vista with Excel 2003 service pack 3

 

[Dave Peterson]

Maybe one of these from Debra Dalgleish's site will help:
http://contextures.com/xlfaqApp.html#ReadOnly
http://contextures.com/xlfaqApp.html#AlreadyOpen

 

[widman]

It happenes whether or not I'm on the network, but they are not in a shared
directory. And it is only certain workbooks. It also happens whether or not I
have excel open for other files. Normally I have 4 to 8 workbooks open at any
given moment.

The recomendadion on that link:
"All of a sudden a number of my Excel 2000 files have become "read-only".

Clear out c:\windows\temp directory on the machine that houses the
files, then reboot."

Is not a viable solution in the middle of the day when you are researching
in 8 web pages, crossing with 6 excel workbooks, answering email and running
other things.

There should be something better than reboot.