tracking changes

[Dan Schultz]

I'm on a network with others. I've created a timesheet in Excel for others
to fill out. They password protect it so third parties can't see it but I
have the password, too. I need a method of preventing people from going back
and changing data in the spreadsheet after I have reviewed it. I know I
probably can't prevent them from making changes but can I somehow detect if
they've altered values to the spreadsheet at some point in the future? I
tried to set it up with a shared workbook using the "track changes" feature
but it doesn't seem to work with password protected workbooks. Any ideas?

 

[JE McGimpsey]

One way:

After reviewing, do a File/Save As... to a local drive, perhaps saving
the new file with the date in the name, and using in a different
password. Then it won't matter if someone makes changes in the original
file, which can still be used by your employees.