Temporary sheet view not working

ausswe

Board Regular
Joined
Feb 19, 2013
Messages
52
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
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?
 
"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
 
Upvote 0
"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.
 
Upvote 0
Solution

Forum statistics

Threads
1,226,771
Messages
6,192,919
Members
453,767
Latest member
922aloose

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top