Does protecting an Excel worksheet stop other people reading it?
TechnologyI protected the formula cells in our planning workbook so they wouldn't be accidentally changed. A colleague said the protection password also meant we could safely include an internal quote sheet in the copy sent to suppliers.
I can open and read the workbook without that password. Microsoft distinguishes file encryption from worksheet protection and says worksheet-level protection isn't intended as a security feature. Excel protection guidance
How would you separate the editable template we need to share from the information we don't intend to distribute? I wanted to protect the calculations, not make an unexamined promise about confidentiality.