Excel Protected Sheet Loses Reference/Format

[Guest]

We have an Excel spreadsheet we are using as an employee expense report. It consists of several entry sheets (all password-protected against format changes) and a final hidden sheet referencing fields from the entry sheets. We use the data in the hidden sheets to upload the information to our legacy AP system. The problem is that occassionally, someone will turn in an expense report and the references in certain cells on the hidden sheet will be lost and those cells will contain the !#REF value. Am I missing something, or is it possible for a user to cause the formatting to change even though the sheets are password-protected?

 

[gilbert]

Hi,

It is very unlikely that a user still able to make changes to th
formatting or delete a sheet. However, a user can still make changes t
the cells that not protected even though the worksheet is protected.

Rgds,
Gilber