Is it possible.. (protecting data)

exceliz

Board Regular
Joined
Sep 26, 2007
Messages
154
Hi

I have this dataset for many organisations which I put into a pivot in excel and created a slicer dashboard with tables etc.
so each organization cancan filter on theirs and double click pivot tables to get their data -
But now I have been told I need to create this so that each organization cant see the actual data behind the charts/tables.

Is it possible to lock down the data to each organization? or would I have to maybe change my idea of a slicer dashboard to something that can be locked down more?

thanks
appreciate any advice on this

Liz x:confused:
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

W8253

Board Regular
Joined
Oct 7, 2015
Messages
64
Depending on your needs and the amount of data in your dashboard:

1) Tell them to flick to your pivot tables tab to see the data behind them. Or change your dashboard so that the pivot table is shown alongside your graph?

2) add data labels to your graphs by rightcklicking the series and choose "Add data labels" --> this will mean that you have the data behind the charts/tables incorporated

If that doesn't help...

3) In case background information is required that is not included in your pivot tables, record a macro that will filter the appropriate columns in your master data. Are you familiar with VBA?
 

Watch MrExcel Video

Forum statistics

Threads
1,129,361
Messages
5,635,804
Members
416,884
Latest member
leeshjay

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top