Share an Excel File Without Exposing Other Users’ Data
Question details
Allow multiple users to submit data without seeing entries from other users.

- Product
- Excel for the web
- Device & OS
- not provided
- Scenario
- Multiple users need to enter information that will be combined in an Excel workbook, while each user’s entries remain hidden from the others.
- Observed behavior
- Excel for the web cannot securely show different columns to different users in the same workbook.
List the fields each user needs to submit and decide who should be allowed to view the combined responses. Check whether your Microsoft Forms account offers the access settings you need.
Collect Individual Entries with Microsoft Forms
Use a form when users only need to submit information and do not need direct access to the shared workbook.
Form respondents submit answers without receiving access to the combined response workbook. The form owner and any authorized collaborators can view responses.
This approach does not let users edit designated columns in a shared workbook or provide a private view of their existing rows.
Open Microsoft Forms, select New Form, and add a question for each field you want to collect.
Open the form settings and choose who can respond. If you need to identify respondents, check the available name-recording or sign-in settings for your account.
Select Collect responses, copy the form link, and send it to the intended users instead of sharing the response workbook.
Open the form’s Responses tab and select Open in Excel. Keep access to the response workbook limited to people authorized to see all entries.

Use Separate Workbooks for Users Who Need to Edit Data
Use individual files when users need to review or update their own entries rather than submit a form.
Review Consolidated Excel Responses in WPS Spreadsheet
WPS Office is a free, lightweight, easy-to-use Office alternative with a familiar interface. Open compatible Excel workbooks to review consolidated responses and move between Office formats with ease. WPS does not enforce user-specific column visibility in a shared workbook.

Frequently Asked Questions
Can I hide different Excel columns from different users?
No. Excel for the web does not provide secure per-user column visibility within one workbook. Use separate files or collect submissions through Microsoft Forms instead.
Will worksheet protection keep other users from seeing hidden columns?
No. Worksheet protection and hidden columns are not sufficient access controls for confidential data. Do not share a workbook containing data that a recipient must not see.
Can form respondents see everyone else’s answers?
Submitting a Microsoft Form does not give respondents access to the combined response workbook. The form owner and authorized collaborators can view responses, so limit their access appropriately.
How do I open Microsoft Forms responses in Excel?
Open the form in Microsoft Forms, select the Responses tab, and choose Open in Excel. Share the resulting workbook only with people allowed to see all responses.
What if users need to edit their previous entries?
Use separate workbooks shared with each user, or consider an application that supports user-specific data permissions. A Forms submission does not provide each user with a private view of a shared Excel workbook.




