Unlinked views in excel files which are stored in MS Teams
If several people use an excel file everyone sees the same selections/filter at the same time (e.g. selection in list hides/unhides Special columns. Unlink option for individual views so that everyone can see another filtered view at the same time.
Hmm... I'm not sure Microsoft could pull this off :( Also, judging by any of the requests here, it seems like a long time to implement (and by long I mean; years).
Great suggestion though!!
Yes, you´re right. But that´s the issue in my case. It is not possible to show individually hidden/unhidden columns dependent from the respective user, which is defined by VBA "environ" for instance. E.g. Columns A, B and C are hidden. User A should only see column A. User B should only see column B and so on also when all 3 open the file at the same time. But reality is that all 3 see the same column. If only one person has opened the file then the "individual view" works.
But that makes sense - It's one file everyone is working in. If you change the view it'll change the view for everyone.