Sheet view in Excel (App) inconsistently working in protected sheets

%3CLINGO-SUB%20id%3D%22lingo-sub-2890783%22%20slang%3D%22en-US%22%3ESheet%20view%20in%20Excel%20(App)%20inconsistently%20working%20in%20protected%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2890783%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20Morning%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20created%20a%20workbook%20and%20uploaded%20it%20to%20a%20TEAM%20for%20sharing%20purposes%20to%20keep%20track%20of%20a%20property%20development%20process.%3C%2FP%3E%3CP%3EI%20understand%20that%20Teams%20use%20the%20Excel%20web%20app.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20workbook%20has%20three%20sheets.%3C%2FP%3E%3CP%3EEach%20sheet%20has%20255%20rows%3C%2FP%3E%3CP%3EEach%20sheet%20have%20certain%20columns%20that%20are%20protected%20(to%20protect%20the%20formulas)%3C%2FP%3E%3CP%3EI%20created%20SHEET%20views%20on%20each%20worksheet%20to%20filter%20certain%20information.%3C%2FP%3E%3CP%3EThe%20sheet%20views%20work%20in%20two%20of%20the%20three%20sheets.%3C%2FP%3E%3CP%3EIn%20the%20third%20sheet%2C%20though%20I%20can%20CREATE%20a%20view%2C%20I%20cannot%20use%20the%20view.%26nbsp%3B%20When%20I%20select%20the%20view%2C%20it%20says%20%22this%20sheet%20is%20protected.%20Some%20parts%20may%20be%20view-only%2C%20and%20can't%20be%20changed%22.%3C%2FP%3E%3CP%3EI%20know%20the%20sheet%20is%20protected.%26nbsp%3B%20So%20are%20the%20other%20two%20sheets.%26nbsp%3B%20However%2C%20I%20can%20use%20the%20views%20in%20the%20other%20two%20sheets.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20insight%20would%20be%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2890783%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Good Morning,

 

I created a workbook and uploaded it to a TEAM for sharing purposes to keep track of a property development process.

I understand that Teams use the Excel web app.

 

The workbook has three sheets.

Each sheet has 255 rows

Each sheet have certain columns that are protected (to protect the formulas)

I created SHEET views on each worksheet to filter certain information.

The sheet views work in two of the three sheets.

In the third sheet, though I can CREATE a view, I cannot use the view.  When I select the view, it says "this sheet is protected. Some parts may be view-only, and can't be changed".

I know the sheet is protected.  So are the other two sheets.  However, I can use the views in the other two sheets.

 

Any insight would be appreciated.

0 Replies