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?
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?