Trick: Allow user to only see their information in Excel

Note: All Excel protection is relatively weak. It is useful to stop casual users but it is not for top secret information.

This is a trick to be able to send out one spreadsheet which contains everyone’s information, but set it up so that a single person can only see their data and not the other users.

To follow along go to 19.8

Lesson tags: vlookup
Back to: POPIA and GDPR Compliance- Built in Excel Tools that will help > Making protected Excel Spreadsheets easier to use