Sheet views NOT KEEPING hidden columns

I'm working in Excel App for Mac and trying to use Sheet Views to make a large shared document easier for multiple departments to use.

Context:

The file is a big operational template where several departments work on the same sheet but each one only needs to see and edit certain columns. My idea was to create saved Sheet Views for each department so that when they switch to their view, only the relevant columns are visible.

What I'm experiencing:

• I create a Sheet View

• I hide the columns that department does not need

• I save the view

But when I switch back to Default View and then return to that saved view, the columns are no longer hidden. Everything is visible again. It seems like the hidden columns are not actually being preserved inside the Sheet View.

What I'm trying to achieve:

Each department opens the file → switches to their view → only sees their relevant columns → edits those fields → changes affect the master sheet.

Would appreciate any workflows people have used for this type of situation.