1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

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.

submitted by /u/SwingAnxious6016
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#generative AI for data analysis
#Excel compatibility
#natural language processing for spreadsheets
#financial modeling with spreadsheets
#rows.com
#big data management in spreadsheets
#conversational data analysis
#financial modeling
#real-time data collaboration
#intelligent data visualization
#Excel
#Privacy Settings
#Password Protect
#Database
#Dashboard
#Data Privacy
#Sensitive Information
#Data Entry
#Financial Data