Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help w/Protecting a Pivot Table through many unique passwords
I have individual data for 1000+ stores. The data is sensitive and cannot be
shared among all users. The quickest way to get this data to the stores is with a Pivot Table, but I'm trying to give each store manager the option to see his/her own store data without the ability to see any other store's data. Can this be done? ...either through a username/password entry when the workbook is opened or by validating a password when they enter their store number? TIA, Nicole |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help w/Protecting a Pivot Table through many unique passwords
There's no reliable way to prevent users from seeing data in an Excel
file. Perhaps you could create a macro that sends each store's data to a separate workbook, and creates a pivot table from that data. NicoleHKeller wrote: I have individual data for 1000+ stores. The data is sensitive and cannot be shared among all users. The quickest way to get this data to the stores is with a Pivot Table, but I'm trying to give each store manager the option to see his/her own store data without the ability to see any other store's data. Can this be done? ...either through a username/password entry when the workbook is opened or by validating a password when they enter their store number? TIA, Nicole -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help w/Protecting a Pivot Table through many unique passwords
Debra - Thanks for the quick reply! I've moved away from the password issue
and now am trying to use the GETPIVOTDATA function in a password protected sheet. I saw several of your posts explaining how to use cell referencing but it's just not working for me - help! When inserting the function, it's only prompting me for the Pivot Table reference and "Name" (text string that refers to part of PivotTable that contains data you want). How can I specify the other variables of the data I want...?? My pivot table is set up with.. Store ID as a row Associate ID as a sub-row # Apps Processed as column....and grouped with 1-2 and 2 Thanks so much for your help!! Nicole "Debra Dalgleish" wrote: There's no reliable way to prevent users from seeing data in an Excel file. Perhaps you could create a macro that sends each store's data to a separate workbook, and creates a pivot table from that data. NicoleHKeller wrote: I have individual data for 1000+ stores. The data is sensitive and cannot be shared among all users. The quickest way to get this data to the stores is with a Pivot Table, but I'm trying to give each store manager the option to see his/her own store data without the ability to see any other store's data. Can this be done? ...either through a username/password entry when the workbook is opened or by validating a password when they enter their store number? TIA, Nicole -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help w/Protecting a Pivot Table through many unique passwords
OK, I got it to return the "total" using a cell reference, but is there a way
to return Associate ID and the "# Applications Processed" related to the Associate ID? THANKS AGAIN! "NicoleHKeller" wrote: Debra - Thanks for the quick reply! I've moved away from the password issue and now am trying to use the GETPIVOTDATA function in a password protected sheet. I saw several of your posts explaining how to use cell referencing but it's just not working for me - help! When inserting the function, it's only prompting me for the Pivot Table reference and "Name" (text string that refers to part of PivotTable that contains data you want). How can I specify the other variables of the data I want...?? My pivot table is set up with.. Store ID as a row Associate ID as a sub-row # Apps Processed as column....and grouped with 1-2 and 2 Thanks so much for your help!! Nicole "Debra Dalgleish" wrote: There's no reliable way to prevent users from seeing data in an Excel file. Perhaps you could create a macro that sends each store's data to a separate workbook, and creates a pivot table from that data. NicoleHKeller wrote: I have individual data for 1000+ stores. The data is sensitive and cannot be shared among all users. The quickest way to get this data to the stores is with a Pivot Table, but I'm trying to give each store manager the option to see his/her own store data without the ability to see any other store's data. Can this be done? ...either through a username/password entry when the workbook is opened or by validating a password when they enter their store number? TIA, Nicole -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help w/Protecting a Pivot Table through many unique passwords
The GETPIVOTDATA function arguments vary for different versions of
Excel. Look in Help for examples for your version, and there are a couple of sample formulas on my web site: http://www.contextures.com/xlPivot06.html NicoleHKeller wrote: OK, I got it to return the "total" using a cell reference, but is there a way to return Associate ID and the "# Applications Processed" related to the Associate ID? THANKS AGAIN! "NicoleHKeller" wrote: Debra - Thanks for the quick reply! I've moved away from the password issue and now am trying to use the GETPIVOTDATA function in a password protected sheet. I saw several of your posts explaining how to use cell referencing but it's just not working for me - help! When inserting the function, it's only prompting me for the Pivot Table reference and "Name" (text string that refers to part of PivotTable that contains data you want). How can I specify the other variables of the data I want...?? My pivot table is set up with.. Store ID as a row Associate ID as a sub-row # Apps Processed as column....and grouped with 1-2 and 2 Thanks so much for your help!! Nicole "Debra Dalgleish" wrote: There's no reliable way to prevent users from seeing data in an Excel file. Perhaps you could create a macro that sends each store's data to a separate workbook, and creates a pivot table from that data. NicoleHKeller wrote: I have individual data for 1000+ stores. The data is sensitive and cannot be shared among all users. The quickest way to get this data to the stores is with a Pivot Table, but I'm trying to give each store manager the option to see his/her own store data without the ability to see any other store's data. Can this be done? ...either through a username/password entry when the workbook is opened or by validating a password when they enter their store number? TIA, Nicole -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
protecting without passwords? | Excel Discussion (Misc queries) | |||
Protecting different cells in Excel with different passwords | Excel Discussion (Misc queries) | |||
sum unique in pivot table | Excel Discussion (Misc queries) | |||
Protecting different ranges with different passwords | Excel Programming | |||
Macro for unprotecting/protecting worksheets WITH passwords | Excel Programming |