Excel 2007: Toggling Read Only Causes File to Lock

[Adam]

Okay, here's the situation... but first a little background:

Affected O/S: Windows XP Pro SP2 and Vista Enterprise SP1
Office Version: 2007 Pro Plus SP1

After opening an Excel workbook that is stored on a network drive, I
click the "Toggle Read Only" button. The top border in Excel now has
"[Read-Only]" after the file name. Great!

Now, if I click again to Toggle Read Only I receive this error:
http://www.filedropper.com/excelroerror

For those who can't see that, the error reads:
Window Title - "File in Use"

"Filename.xls is locked for editing

by 'another user'.

Click 'Notify' to open a read-only copy of the document and receive
notification when the document is no longer in use."

There are two options available: Notify and Cancel. They both do
essentially the same thing -- close the error message -- but neither
allows the file to change from Read-Only.

When doing this with the same exact file from a local drive, you can
switch to/from Read Only at will. This is happening on any file I
try... both in compatibility mode (.xls) and native mode (.xlsx).

Any help would be greatly appreciated.

Thanks,
Adam

 

[Adam]

One more thing. If I put the workbook in "Shared" mode, the behavior
goes away. That's not a solution, though... just an observation.