Forum Discussion
Sharing Data in Excel
Hi, I currently have a spreadsheet with multiple (5) sheets. I want to grant access to data to a person of one of the sheets and not the others. What would be the best way of going about this?
Hello mkidman,
Excel does not allow restricting access to individual sheets within a single workbook. The safest approach is to move the sheet you want to share into a separate workbook and share only that file. Sheet protection can prevent editing but does not hide sheets, and hidden sheets can be unhidden. If using OneDrive or SharePoint, you can store each sheet in a separate workbook and manage view or edit permissions individually. For read-only sharing, exporting the sheet as a PDF or CSV is also a secure option.