Dynamic Table
Sorry,
I have a dynamic table with SalesMen in Page and a lot of data as sales values, regions, etc.. I'd like to share the DT with all salesmen, but w/o allowing them to see all data, so each one see only its data. Whenever I save the DT each one has access to all data. How to save and allow each salesmen to see only his data. thks and sorry for the portuguese message before - it's monday!! -- Agarb Carvalho Gefran Brasil |
Dynamic Table
If you filter by Salesperson and then protect the worksheet that the Pivot
Table is on, that salesperson will not be able to change the pivot table to view other data. Don't forget to use a password :O -- Hope this helps. If this post was helpfull, please remember to click on the ''''YES'''' button at the bottom of the screen. Thanks, Gary Brown "Agarb Carvalho" wrote: Sorry, I have a dynamic table with SalesMen in Page and a lot of data as sales values, regions, etc.. I'd like to share the DT with all salesmen, but w/o allowing them to see all data, so each one see only its data. Whenever I save the DT each one has access to all data. How to save and allow each salesmen to see only his data. thks and sorry for the portuguese message before - it's monday!! -- Agarb Carvalho Gefran Brasil |
All times are GMT +1. The time now is 05:28 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com