Temporary sheet view not working

[ausswe]

Hi, I have created a spreadsheet, saved on SharePoint, for colleagues to look up information entered in one cell (B3) and displaying the result using the FILTER formula in B11.
That all works well, however as there are a number of colleagues using the file at the same time I have instructed them to active Sheet View in order to be able to use it simultaneously and they've done so but they all see the changes when someone else enters a value in B3 and filters that result.

Since I have a mix of colleagues where some use the Desktop app and others use the files on the Web or Teams I created scripts and VBA to activate Temporary Sheet View which they have been using. Temp Sheet View is activated but they see eachothers changes. So I thought the issue might be that it's saved as a macro-enabled workbook. Changed to a standard .xlsx file - and activated Temp Sheet View manually. Same result.

I did find an old post online suggesting that merged cells might have been a contributing factor (which I used) so I unmerged those cell, but still the same result.

Has anyone encountered this problem and found a way for it to work?

 

[NdNoviceHlp]

"they all see the changes when someone else enters a value in B3 and filters that result" & "but they see eachothers changes" That's what Sharpoint does. Where's the problem???? Dave

 

[ausswe]

"they all see the changes when someone else enters a value in B3 and filters that result" & "but they see eachothers changes" That's what Sharpoint does. Where's the problem???? Dave

Hi Dave, that was a lot of question marks mate. The problem Dave was that they had temporary sheet view active and then their changes shouldn’t impact them visually as they work in their view.

But I’ve just figured out that sheet view only work with the filter function and not with the filter formula.