first of all i'm new to sharepoint. I found quite similar question to mine
http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010general/thread/9f23a77c-1527-48a8-abbc-2ccded736d9e but unfortunately it hasn't been answered.
So what i have done so far:
I made a Excel 2010 Powerpivot chart and Published it to sharepoint via the Powerpivot gallery. I also created a Excel web part with the spreadsheed in it.
I am searching for a vba script to achieve the sharepoint username but found only some for the windows username. I also managed to disable slicers in vba.
What i want to achieve:
Due to the fact that the Powerpivot chart has some critical security data in it the different users should only see two different filter options (whole data and one slice for themself)
So i need to disable slicers in the pivot chart tue to the sharepoint accounts.
Is it possible?
If yes, how! Any help would be appreciated.
Is it possible via VBA or do i have to use Excel web scervices?
Thanks for your help :)
View Complete Post