Problem with Toggle Read-Only button Excel 2007

[GlennUK]

Hi all,

I have a problem with Excel 2007 ... it's been a while since I asked a question here ... I'm usually answering ( so, no, I'm not a beginner ).

If I open a file as read-only, and make a change, and then press the Toggle Read Only button ( in QAT from Category "Commands Not In The Ribbon" ), I get the message:

File Changed
You have made changes to 'my_filename.xlsx'.
Another user has also made changes. What would you like to do?
Click Discard to discard your changes and edit the latest version.
Click Save as to save your changes to a different file and open the latest version.
( with buttons = "Discard" "Save as" "Cancel" )

This is an erroneous message, and this does not happen with this button in Excel 2002/2003. Is there some setting I have to set to get this button working correctly, maybe in the Registry?

I have Excel version number 12.0.6550.5000




Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[GlennUK]

By the way, I posted this in EggheadCafe last week ... with no response ... just for info:

http://www.eggheadcafe.com/communit...07-toggle-read-only-button-error-message.aspx

... as I couldn't get my access to Tek-Tips from my work PC working last week ( long story ).

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[dcompto]

Are you working with files from a network share? If so, see the hotfix at

http://support.microsoft.com/kb/977030

 

[GlennUK]

Thanks for suggesting that, but going down that route was not successful.

I'll keep trying to find some commonality amongst the files where this happens, and see if that sheds any light on the cause.

Cheers, Glenn.

Beauty is in the eye of the beerholder.