Filters and Hidden Columns in SharePoint Excel just randomly unfilter and unhide themselves

Anonymous

Hello,

We have created several excel sheets which we then move to become sharepoint files. Each user has created their own sheet view in any given file, and is supposed to work in their view, as there can be 2-4 of us in the sheet at the same time. We each apply our own hidden columns and filters to the file for the part we are working in. Randomly, while working, the sheet will just unhide all columns or unfilter itself in sheet view. This happens to each of us. Even if we choose to edit in Excel and not in sharepoint, it happens. Sharepoint defaults to Microsoft Edge office 365 excel app. How do we stop this from happening? It is super frustrating.

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

7 answers

Anonymous

2024-05-17T16:16:41+00:00

I am also experiencing the same situation. No one is changing it. We are finding that all of our spreadsheets are un-hiding once opened. Interesting that it is not just our institution that it is happening with but others also. I have spent way to many hours trying to fix this. Very frustrating for us non-techie folks.
Was this answer helpful?

0 comments No comments
Anonymous

2024-05-03T17:49:36+00:00

How can I reproduce your issue?

I'd suggest you raise it to Microsoft for such bug.

Please contact your admin/IT department create a support ticket via Microsoft 365 Admin Center> Support> New service request. Support team there will have the correct channel and resources to help you investigate more and find what exactly the reason has caused this situation.

Get support - Microsoft 365 admin | Microsoft Learn

About how to find the admin in your organization, you can refer to How do I find my Office 365 admin
Was this answer helpful?

0 comments No comments