If you don't want salespeople to see other people's data, base their
pivot table on only their sales data. You can use a filter to extract
their data from the source, then base the pivot table on that.
RUSH2CROCHET wrote:
I have a rather large pivot table, which displays (2) years of monthly sales
data for 10 different salespeople. I would like to distribute among my
staff, but without allowing the sales staff to view data pertaining to other
salespersons, which is not relative to them. How would I accomplish this?
All assistance appreciated!
TIA,
Sandi
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html