Hello,
Anyone have a good idea on how to limit user access to data in a Pivot
table. I have ONE pivot which I want to use as a basis for several users
(who should not see each others data).

My thought was to create a user access list (username, passw, access level
to pivot), and then dynamically filter the data in the pivot based on this
input.

Limitation - Excel 2000.