File Sharing Problems

Share an Excel File Without Exposing Other Users’ Data

Muhammad TalhaMuhammad Talha Nov 18, 2026 868 views

Question details

Allow multiple users to submit data without seeing entries from other users.

Share an Excel File Without Exposing Other Users’ Data
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.
Before you start

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.

Solution 1Recommended

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.

1
Create a form

Open Microsoft Forms, select New Form, and add a question for each field you want to collect.

2
Set response access

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.

3
Send the form

Select Collect responses, copy the form link, and send it to the intended users instead of sharing the response workbook.

4
Review responses in Excel

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.

Collect Individual Entries with Microsoft Forms
Hidden columns are not private access controls: Hiding columns or using workbook or worksheet protection does not securely restrict confidential data to individual users.
Free Microsoft Office alternative

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.

Review and organize consolidated form responses in WPS SpreadsheetCompatible with Microsoft Excel formats, including XLSX and XLSFamiliar spreadsheet interface for an easier transitionFree and lightweight for everyday office work
microsoft office alternative - wps office

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.