Forum Discussion

Léa's avatar
Léa
Copper Contributor
Nov 17, 2024

Have you notice some issue with sheetviews

Hello everyone, 

i have to create multiple sheetviews to enable my user to have a specific view depending on their company name. 20 users are using the same Excel file and need to be able to have a specific view based on filter on the company name.

I have created muttiple sheetviews but I noticed that sometimes:

-SheetViews does not work anymore

-SheetViews are showing wrong wiews

2 questions:

-have you ever noticed this issue?

-Have you an other solution to achieve my goal?

 

Thanks a lot for your help

  • peiyezhu's avatar
    peiyezhu
    Bronze Contributor

    Is a Sheet View private, and only for me? No, other people who share the workbook can see views you create if they go to the View tab and look at the Sheet View menu in the Sheet Views group.

    https://support.microsoft.com/en-us/office/create-and-manage-sheet-views-in-excel-0eea3dc5-d7d1-44c5-a953-25ebfbd6c1a6

    • Léa's avatar
      Léa
      Copper Contributor

      Hello, thank you for your answer. No, the views are visible by all the users. And, it is the goal? so that the users can choose their own views

Resources