Privacy Setting for Excel
So I have a question for the excel experts out there. I’m still fairly new to excel and need help adjusting privacy settings on my excel. So I have a sheet the is labeled “Database” that stores a bunch of entries for invoices my company has for the year. I have another sheet in the same workbook labeled “dashboard” that has some sensitive financial information on it.
I want to be able to share it with a coworker where she can only see the database side so she can help me enter data point, however I don’t want her to be able to see the dashboard sheet. However, I want my bosses to be able to have access to it easily, they aren’t always the most tech savvy so hiding the sheet may not be the best option. Maybe try and password protect the sheet?
For reference we also only use the one drive and excel online version, I know sometimes that doesn’t offer all of excels options.
[link] [comments]
Want to read more?
Check out the full article on the original site