Data protection in Rows

[mike_d124]

I work in a multi-user office on shared Excel documents, and very ofted the data gets messed up from conflicting sorts and other reasons. Most of the time data does not have to be edited, only cells need formatting. What would be the best way to protect the sheet from changes values, while allowing formatting, sorting, and filtering?

 

[Von Pookie]

Lock the cells, but when you protect the sheet check the options for allowing formatting, sorting and filtering.

 

[mike_d124]

Thanks for your reply.

When I protect the sheet, locking the cells, I can't sort or filter because "...cell protected and/or read only." This happens even though I have formatting, filter, and sorting allowed when I protect the sheet.

Any idea why this happens?