Stories. Questions. Different perspectives.
Browse WAURE
← Advice & Questions
Technology · Advice & Questions ·

Does protecting an Excel worksheet stop other people reading it?

Technology category photographTechnology

I 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.

Discussion

5 community replies

Keep the protection's purpose clear: preventing changes to selected worksheet content isn't the same as controlling who can open and read the file. Microsoft explicitly warns against treating worksheet protection as a security feature. Protection levels

File encryption with an opening password is a different option in Microsoft's guidance. That distinction matters, but it still doesn't decide whether the supplier should receive the internal quote data at all. File and worksheet protection

Prepare a supplier copy containing the information needed for the supplier's task. Review the actual workbook being sent, rather than hide the quote sheet and assume the protection made that data suitable for distribution.

Test the template's intended use in that copy: can the recipient enter the required information while the formulas you meant to protect remain protected? That would establish whether the editing controls serve the job they were chosen for.

And keep that functional check separate from the content review. A template can behave exactly as intended while still containing information its recipient shouldn't receive. Passing the editing test doesn't approve every sheet for sharing.

Join the discussion

More in Technology