Debra Dalgleish's site has an answer to this FAQ:
http://www.contextures.com/xlfaqApp.html#ReadOnly
Q. All of a sudden a number of my Excel 2000 files have become "read-only".
A. Clear out c:\windows\temp directory on the machine that houses the files,
then reboot.
Cleaning out the windows temp folder deletes a few files that excel uses to keep
track of what's currently open.
And rebooting will kill any hidden instance of excel--usually kept open by excel
crashing.
This might work (sometimes!):
If you can close all the visible instances of excel. Then try to show the
hidden instances.
One way is to use a VBS script. Here are two that I have (with shortcuts to
them on my desktop):
copy this code into Notepad and save it as UnHideWord.VBS
Dim WD
On Error Resume Next
Set WD = GetObject(, "Word.Application")
If Err.Number = 429 Then
MsgBox "Word is not running"
Else
WD.Visible = True
End If
On Error GoTo 0
Set WD = Nothing
========
Do the same thing with this code, but call it UnHideXL.VBS
dim myXL
On Error Resume Next
Set myXL = GetObject(, "Excel.Application")
If Err.Number = 429 Then
msgbox "excel is not running"
else
myxl.visible = true
end If
On Error GoTo 0
Set myxl = nothing
========
Each time you run one of these, you'll either unhide a visible instance so you
can close it.
Repeat until you get the "...is not running" message.
Then clean up the temp folder and see if she has to reboot.
User is trying to open a spreadsheet on a shared folder on
the LAN. NTFS permissions on the folder say she should
have full access to the file. Often, when she opens it,
error message: "Cannot access read-only document
[filename]" appears. Sometimes, if she logs out and logs
back in, she can open the document.
No other user has the doc open.
Permissions are correct. Folder is on an NT4.0 server,
user is on a dog of a PC running Win95 and Office 97.
Suggestions?
BH
