Forum Discussion

Erik_Andersen's avatar
Erik_Andersen
Copper Contributor
Jun 17, 2020

Excell Shared Spreadsheets

we have a shared excel spreadsheet with adaptive views for various reasons. the issue we have is that when one user uses an adaptive filter it changes the view for everyone using the spreadsheet and stops us from changing our views. when the user has finished their changes they restore the view and the other users can now use the spreadsheet again. is there a way to turn this off so when each user changes their filter/view it doesnt change the other users view?

excel

2 Replies

  • Avani_Reddy's avatar
    Avani_Reddy
    Icon for Microsoft rankMicrosoft
    Jun 18, 2020

    Erik_Andersen Hi Erik, have you used the feature Sheet Views in Excel on the Web? This feature can help you when coauthoring with others in a spreadsheet and you don't want your sorts or filters to be impacted by others. Are you using desktop or Excel on the Web?

    • Erik_Andersen's avatar
      Erik_Andersen
      Copper Contributor
      Jun 18, 2020

      Avani_Reddy  thanks we are excel on desktop. i have started using the browser version but this is incredibly laggy and doesnt have the same features as the desktop version. just appears to be a cut down version of excel. really frustrating as im in and out of many views all day and i have pretty much now added hours more time to do the same thing 

Resources