Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic pivot table | Excel Discussion (Misc queries) | |||
Dynamic Table | Excel Worksheet Functions | |||
dynamic range with a table below the working table | Excel Worksheet Functions | |||
Dynamic Table | Excel Discussion (Misc queries) | |||
Dynamic Table | Excel Discussion (Misc queries) |