Is there a way to set up an excel spreadsheet, requesting a password to open,
but the password used will determine the data that can be seen by the user.

For example I have set up some sales tools that show performance at various
hierarchial levels:- national, regional, territory. I would like those people
with national access to be able to view all data, regional access to just
view their region and the territories in that region, and territory access to
just view their territory.

Thanks

Graham