I have a large excel 365 worksheet that multiple people use. I am trying to create sheet views for multiple people so when they open the sheet they can go to their sheet view and only the columns they use are visible. I click new and hide the columns they do not need and then click keep. I then change the name under options to the name I want.
When I go to a different view and come back all the hidden columns are back. HELP!