Forum Discussion
Spreadsheet views on Co-authored Spreadsheets
Me and my colleagues have a shared spreadsheet which is co-authored, we have an account handler column which we can filter by our own initials to be able to view just our clients on the spreadsheet.
The issue I'm having is often the default view is changing to a view with just one of my colleagues with the initials SD showing for all the rest of us.
Would anyone know how to stop this happening, I have had this issue for months.
Kind Regards
1 Reply
You’re running into a pretty common problem with Excel for the web / co-authored workbooks where people apply filters, and those filters overwrite what others are looking at.
In co-authored Excel files (OneDrive/SharePoint), filters are shared by default.
If someone applies a filter (e.g. “SD” in your Account Handler column), that same filter applies to everyone else — so suddenly the whole workbook only shows SD’s clients for all users.
There are two good approaches:
Option 1 — Use Personal Filter Views
- In Excel for the Web:
- Go to View tab.
- Click New View (sometimes called Custom View or Sheet View depending on version).
- Choose Private View.
- Apply your filter (e.g., your initials).
- Save it.
Now, your filter won’t affect anyone else, and you can quickly switch between your view and shared views.
In Excel desktop (with 365 connected workbooks), this shows up as Sheet View. Look for the little “eye” icon in the sheet tab area when you filter — it means you’re in your own private view.
Option 2 — Use “My View” as Default
If you want to always open the file with your filter:
- Set up your Sheet View (see above).
- Save and exit the workbook while in that view.
- When you re-open, Excel will return to your personal view (instead of overriding with someone else’s).
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark as best response and like it!
This will help all forum participants.
