cell unprotected in excel 2003 but protected in excel 97 and 2000?

[Gary Massengale]

My boss sent out an excel sheet that had one unprotected column for people
to enter data, the rest was write-protected so no one can change his
formulas.
He has 2003, as do I. He sent a copy to other users, some of whom have
excel 2000, others excel 97. When they try to enter the amounts in the
un-protected column it tells them that cell is protected.

HOWEVER - he sends the same file to me, and I can enter data no problem.
As far as I knew there were no compatability problems between excel 2003 and
previous versions, but then why can I enter data in the unprotected cells
but users with previous versions of excel cannot?

Any help would be appreciated.

gary

 

[Bernard Liengme]

Gary,
Using Excel 2003, I made a simple workbook; I unprotected ("unlocked"
A1:A10) and protected the worksheet. I took this to a PC with XL97 and
opened the file. I was able to add to A1:A10 but not to anywhere else.

 

[Gary Massengale]

Same here. Must be something in how he protected the file that allows me to
enter data with Excel 2003, but will not allow the users with 2000 or 97 to
do so.
Just dont know what it could be. And he's not going to like me telling him
that. oh well.

thanks,
gary