Excel 97 - disappearing modify password

[LeCras]

One of our users has a problem we haven't come across before. He has a spreadsheet that used to be protected against modifications with a password. All of a sudden the password has disappeared. There is no errors when he tries to set a password, it just doesn't prompt him for one when he goes in to modify the spreadsheet and when you go back into File > Save As the password field is blank.

I tried setting a password on my PC, which is running Office 2000 rather than 97, and the password stayed fine for me. However, when the user tried to change the password from his machine it disappeared again!

If anyone has any ideas I would be really grateful.

The user is running Windows NT 4.0 SP6 with a standard Office 97 installation.

Many thanks,

C. Le Cras

 

[xlhelp]

Is there any chance the user is saving the file to lower version of XL?

 

[LeCras]

I'm afraid not - I've watched him do this a couple of times and he's not doing anything wrong.