Data Analysis in a Protected Sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-1841952%22%20slang%3D%22en-US%22%3EData%20Analysis%20in%20a%20Protected%20Sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1841952%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20day%2C%3CBR%20%2F%3E%3CBR%20%2F%3EI%20am%20new%20here%20and%20I%20was%20hoping%20a%20can%20get%20some%20help.%20I've%20created%20a%20sheet%20that%20my%20classmates%20like%20using%20for%20our%20Quantitative%20Business%20Tools%20class.%20The%20problem%20is%20that%20they%20keep%20altering%20the%20formulas%20and%20have%20asked%20me%20to%20make%20it%20user%20friendly.%20I%20decided%20to%20protect%20the%20sheet%20allowing%20the%20students%20to%20only%20input%20information%20on%20selected%20cells.%20The%20problem%20then%20becomes%20that%20some%20of%20my%20formulas%20rely%20on%20a%20data%20regression%20analysis%20which%20I%20can%20no%20longer%20conduct%20on%20a%20protected%20sheet.%20Is%20there%20any%20way%20around%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1841952%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1849045%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20Analysis%20in%20a%20Protected%20Sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1849045%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F853320%22%20target%3D%22_blank%22%3E%40Philomath%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESomebody%20else%20will%20have%20to%20answer%20your%20actual%20question%3B%20I%20have%20no%20idea%20whether%20there's%20a%20way%20around%20the%20experience%20of%20protection%20interfering%20with%20data%20regression%20analysis.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20since%20these%20are%20your%20classmates%20in%20a%20business%20analysis%20course%20of%20some%20kind%20(undergrad%20or%20graduate%3F)%2C%20it%20occurs%20to%20me%20that%20you%20could%20suggest%20that%2C%20at%20the%20very%20least%2C%20they%20just%20%3CU%3E%3CEM%3E%3CSTRONG%3Etake%20a%20copy%20of%20your%20original%20sheet%3C%2FSTRONG%3E%20%3C%2FEM%3E%3C%2FU%3Eand%20then%20work%20independently%2C%20altering%20your%20formulas%20if%20they%20must%20%3CU%3Eon%20their%20own%20copies%3C%2FU%3E--it%20would%20help%20them%20learn%20to%20use%20the%20Excel%20tool%20themselves%2C%20surely%20one%20of%20the%20objectives%20of%20the%20course--and%20leave%20you%20free%20to%20accomplish%20your%20data%20regression.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Good day,

I am new here and I was hoping a can get some help. I've created a sheet that my classmates like using for our Quantitative Business Tools class. The problem is that they keep altering the formulas and have asked me to make it user friendly. I decided to protect the sheet allowing the students to only input information on selected cells. The problem then becomes that some of my formulas rely on a data regression analysis which I can no longer conduct on a protected sheet. Is there any way around this?

1 Reply
Highlighted

@Philomath 

 

Somebody else will have to answer your actual question; I have no idea whether there's a way around the experience of protection interfering with data regression analysis.

 

But since these are your classmates in a business analysis course of some kind (undergrad or graduate?), it occurs to me that you could suggest that, at the very least, they just take a copy of your original sheet and then work independently, altering your formulas if they must on their own copies--it would help them learn to use the Excel tool themselves, surely one of the objectives of the course--and leave you free to accomplish your data regression.