Forum

Notifications
Clear all

File Security

2 Posts
1 Users
0 Reactions
97 Views
(@yingsi22)
Posts: 3
Active Member
Topic starter
 

Hello, I have created an excel dashboard that will be shared with colleagues and I would like to hide all the database and working sheets only showing the dashboard sheet. 

Understand that there is an option of setting the sheets as very hidden, but my concern is anyone who knows about this function would know how to unhide it (some detailed information that I rather they do not see). I have also tried to password protect each sheet before setting as very hidden so that the data in each sheet cannot be easily extracted should anyone be able to unhide it. But the problem with password protecting every sheet is that the slicers on the dashboard sheet no longer works.

Is there any other way around this?

 

Thanks

Ying Si

 
Posted : 30/06/2021 12:06 am
(@yingsi22)
Posts: 3
Active Member
Topic starter
 

Resolved!

When adding password to protect sheet, select only "Use Autofilter" and "Use PivotTable and PivotChart" Wink

 
Posted : 30/06/2021 12:57 am
Share: