Protect Separate Excel Sheets for Each User
Question details
The user wants each person to access only their own Excel worksheet using a separate password.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Multiple users need access to their own data without seeing other users' worksheets.
- Observed behavior
- Each user should be able to open only the information intended for them.
Identify which worksheet belongs to each user and where the files will be stored. Check whether formulas reference other sheets, because those links may need to be updated when sheets are separated.
Separate Worksheets into Files and Restrict Access
Use file-level permissions when users must not see one another's data.
Excel worksheet protection is designed to limit changes, not to keep confidential data secure from someone who has the workbook. Separate files provide a more appropriate access boundary.
In Excel, right-click a sheet tab, select Move or Copy, choose (new book), and select Create a copy. Repeat for each user.
Review the new workbook for external links, hidden sheets, and other data that should not be shared. Use File > Save As to save a separate file for each user.
Upload the files to OneDrive or SharePoint in a location where you can manage access. Check folder and site permissions so that unintended users do not inherit access.
For each file, select Share, choose Specific people, enter the intended user's account, and select the appropriate viewing or editing permission. Use Manage access to review existing permissions.

Encrypt Each Separate Excel File with a Password
Use file encryption as an additional safeguard when distributing separate workbooks.
Create Password-Protected User Files in WPS Spreadsheets
Use WPS Spreadsheets to create a separate workbook for each user and encrypt each file with its own password. Share each file only with its intended recipient.
- 1. Open the workbook: Open the Excel workbook in WPS Spreadsheets and identify the sheet intended for each user.
- 2. Create separate files: Copy each user's sheet into a new workbook using the sheet tab's Move or Copy option, then use Save As to save each file separately.
- 3. Check the contents: Open each new file and inspect its sheets and formulas to ensure it does not expose another user's data.
- 4. Encrypt and share: Use the file encryption option under Menu > File or Tools, depending on your WPS version, to set a unique open password for each file. Save the file and send its password separately.

Frequently Asked Questions
Can I give each Excel worksheet a different password?
Yes. Use Review > Protect Sheet on each worksheet to set a protection password. However, sheet protection limits editing and is not a reliable way to prevent someone with the workbook from viewing confidential data.
Does hiding a worksheet prevent other users from seeing it?
No. Hidden worksheets are not a confidentiality boundary. Put sensitive data in separate files and restrict access to each file instead.
How do I check who can access a shared file?
In OneDrive or SharePoint, select the file and open Manage access to review its sharing links and permissions. Also check inherited folder and site permissions.
What happens to formulas when I move a sheet to a new workbook?
Formulas that refer to other sheets may become external links or require updates. Review the formulas in each new workbook before sharing it.




