Excel Sheet synced with Forms - Filtering

Question

I will have 50+ people using the shared excel sheet to monitor Form submissions. I am looking for a way (or setting) to use filters for each employee to filter to their name and only see new entries that have their name in the filtered column. Currently, when a column is filtered to a specific name, all new entries are shown regardless of the name in that column. You have to refresh the filter constantly to remove the undesired entries from view. Does anyone know if this is possible?

Answer 1

Yes, that works but was looking for a way to not have to refresh due to the amount of data and expected frequency that it will be coming in at. Thanks for the quick responses so far! I will keep searching and testing and report back if I find a way.

Answer 2

When new data comes, you may need to reset the filter to trigger the update.

Answer 3

Just tested sheet view and doesn't seem to solve for my issue. I created a sheet view with a filter selected on one of the columns. I entered a new entry on Forms with text that does not match what my filter was set to but the new entry populated in my view.

Any other settings with sheet view that may solve this that you could share?

Answer 4

and only see new entries that have their name in

https://support.microsoft.com/en-us/office/create-and-manage-sheet-views-in-excel-0eea3dc5-d7d1-44c5-a953-25ebfbd6c1a6

Frequently Asked Questions

Is a Sheet View private, and only for me? No, other people who share the workbook can see views you create if they go to the View tab and look at the Sheet View menu in the Sheet Views group.

Answer 5

You may create sheet view for each user. Then let user to see their own data by changing sheet view.

Create and manage Sheet Views in Excel - Microsoft Support