Multiuser sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-148342%22%20slang%3D%22en-US%22%3EMultiuser%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-148342%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%0A%3CP%3E%3CEM%3E%3CSTRONG%3ECan%20I%20create%20a%20multiuser%20sheet%3F%3C%2FSTRONG%3E%3C%2FEM%3E%3CBR%20%2F%3EI%20would%20like%20to%20create%20something%20like%20this%3A%3C%2FP%3E%0A%3CP%3E%3CEM%3EUsers%20%3A%20U1%3B%20U2%3B%26nbsp%3BU3%3C%2FEM%3E%3CBR%20%2F%3E%3CEM%3EName%20of%20test%3A%20AAA%2C%20BBB%2C%20CCC%3C%2FEM%3E%3CBR%20%2F%3E%3CEM%3ENumber%20of%20test%3A%20...%3C%2FEM%3E%3C%2FP%3E%0A%3CP%3EU1%20can't%20see%20U2%20and%20U3%20data.%20U2%20can't%20see%20U1%20and%20U3%20data.%3C%2FP%3E%0A%3CP%3EAdmin%20can%20see%20all%20data%3C%2FP%3E%0A%3CP%3EToday%20we%20have%2046%20users%20and%2046%20sheets%20(I%20would%20like%20to%20write%20**bleep**%2C%20not%20sheet...).%3CBR%20%2F%3EThe%20easy%20way%20is%20to%20develop%20a%20little%20database%20with%20a%20Web%20application%2C%20but%20my%20company%20don't%20want%20an%20IT%20development%20for%20many%20reasons.%3CBR%20%2F%3EThank%20you%20for%20the%20help.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-148342%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-149069%22%20slang%3D%22en-US%22%3ERe%3A%20Multiuser%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-149069%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20Tim%2C%3C%2FP%3E%0A%3CP%3EI%20did%20not%20know%20I%20could%20change%20al%20sheet%20in%20one%20time%2C%20this%20is%20a%20way.%3C%2FP%3E%0A%3CP%3ESecond%20question%20if%20I%20create%20Sheet1%20for%20User1%2C%20S2%20for%20U2%2C%20etc.%20can%20I%20share%20S1%20ONLY%20for%20U1%20and%20S2%20only%20for%20U2%20and%20so%20on%3F%20I%20think%20no!%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20find%20this%20in%20a%20forum%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Fmsoffice%2Fforum%2Fmsoffice_excel-mso_other-mso_o365b%2Foffice-365-excel-workbook-share-only-one-worksheet%2F16fdf6b5-4876-4e0f-9b07-629a3c2ef00e%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EOffice%20365%20Excel%20Workbook%20-%20share%20only%20one%20worksheet%3C%2FA%3E%26nbsp%3B.%20Now%2C%20if%20I%20use%20this%20way%20and%20I%20want%20to%20modify%20a%20field%20or%20add%20a%20new%20field%2C%20I%20need%20to%20modify%20all%2046%20sheet.%20Right%3F%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPS%3A%20For%20Access%2C%20to%20easy%20for%20me%20I%20love%20Access%2C%20but%20I'm%20online%20(OneDrive)%20and%20not%20in%20local%20network%20and%20they%20don't%20want%20an%20IT%20solution.%20I%20have%20already%20developed%20an%20Oracle%20Apex%20application%2C%20fully%20Web%2C%20perfect%20solution%2C%20but%20they%20want%20a%20solution%20updatable%20by%20an%20end%20user%20(No%20comment).%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-149067%22%20slang%3D%22en-US%22%3ERe%3A%20Multiuser%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-149067%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Francesco%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20want%20to%20change%2046%20sheets%20at%20the%20same%20time%2C%20you%20can%20select%20all%20of%20the%20sheets%20(select%20the%20first%20sheet%2C%20hold%20the%20Shift%20button%20down%20and%20select%20the%20last%20of%20the%2046%20sheets%2C%20assuming%20they're%20in%20a%20row)%2C%20and%20when%20you%20make%20changes%2C%20it%20will%20apply%20them%20simultaneously%20to%20all%20sheets.%26nbsp%3B%20Would%20that%20solve%20your%20problem%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOtherwise%2C%20you%20might%20find%20that%20if%20it's%20just%20data%20entry%20that%20you're%20looking%20for%2C%20an%20Access%20solution%20might%20be%20a%20better%20alternative.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EKind%20regards%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETim%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-149064%22%20slang%3D%22en-US%22%3ERe%3A%20Multiuser%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-149064%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Tim%2C%3CBR%20%2F%3ETHank%20you%20for%20your%20answer%2C%20but%20this%20solution%20is%20our%20actual%20solution.%20Each%20user%20has%20their%20own%20sheet%20(46%20sheet!!!).%20I%20can't%20continue%20in%20this%20way%2C%20because%20if%20my%20boss%20ask%20to%20me%20to%20add%20a%20new%20field%2C%20feature%2C%20or%20other%2C%20I%20must%20to%20change%2046%20sheet.%3CBR%20%2F%3ETHe%20best%20way%2C%20now%20I%20think%20possible%20only%20with%20VBA%2C%20is%20one%20sheet%20with%20an%20automatic%20filter%20to%20hide%20data%20of%20other%20users.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-149035%22%20slang%3D%22en-US%22%3ERe%3A%20Multiuser%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-149035%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Francesco%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThere%20are%20more%20complicated%20macro%20solutions%20that%20you%20can%20set%20up%2C%20so%20that%20a%20user%20needs%20to%20%22log%20in%22%20to%20their%20sheet%20(e.g.%20input%20username%20and%20password)%2C%20but%20if%20you%20don't%20want%20to%20go%20down%20that%20sort%20of%20path%2C%20perhaps%20you%20can%20let%20each%20user%20have%20their%20sheet%2C%20and%20use%20Get%20and%20Transform%20(Power%20Query)%20to%20pull%20all%20the%20results%20into%20a%20separate%20Admin%20sheet%3F%26nbsp%3B%20That%20way%2C%20Admin%20doesn't%20need%20to%20open%20up%20each%20sheet%20to%20see%20the%20data%2C%20they%20can%20just%20hit%20'refresh'%20and%20all%20of%20the%20data%20will%20be%20available%20to%20them.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWould%20either%20of%20those%20ideas%20solve%20your%20issue%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETim%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1979174%22%20slang%3D%22en-US%22%3ERe%3A%20Multiuser%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1979174%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F76691%22%20target%3D%22_blank%22%3E%40Francesco%20Cavalli%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ehi%2C%20Is%20your%20problem%20solved%3F%20I%20am%20also%20looking%20for%20solution%20for%20such%20issue.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello,

Can I create a multiuser sheet?
I would like to create something like this:

Users : U1; U2; U3
Name of test: AAA, BBB, CCC
Number of test: ...

U1 can't see U2 and U3 data. U2 can't see U1 and U3 data.

Admin can see all data

Today we have 46 users and 46 sheets (I would like to write **bleep**, not sheet...).
The easy way is to develop a little database with a Web application, but my company don't want an IT development for many reasons.
Thank you for the help.

 

 

5 Replies

Hi Francesco,

 

There are more complicated macro solutions that you can set up, so that a user needs to "log in" to their sheet (e.g. input username and password), but if you don't want to go down that sort of path, perhaps you can let each user have their sheet, and use Get and Transform (Power Query) to pull all the results into a separate Admin sheet?  That way, Admin doesn't need to open up each sheet to see the data, they can just hit 'refresh' and all of the data will be available to them.

 

Would either of those ideas solve your issue?

 

Tim

 

 

Hi Tim,
THank you for your answer, but this solution is our actual solution. Each user has their own sheet (46 sheet!!!). I can't continue in this way, because if my boss ask to me to add a new field, feature, or other, I must to change 46 sheet.
THe best way, now I think possible only with VBA, is one sheet with an automatic filter to hide data of other users.

Hi Francesco,

 

 

If you want to change 46 sheets at the same time, you can select all of the sheets (select the first sheet, hold the Shift button down and select the last of the 46 sheets, assuming they're in a row), and when you make changes, it will apply them simultaneously to all sheets.  Would that solve your problem?

 

Otherwise, you might find that if it's just data entry that you're looking for, an Access solution might be a better alternative.

 

Kind regards,

 

Tim

Thank you Tim,

I did not know I could change al sheet in one time, this is a way.

Second question if I create Sheet1 for User1, S2 for U2, etc. can I share S1 ONLY for U1 and S2 only for U2 and so on? I think no!

 

I find this in a forum: Office 365 Excel Workbook - share only one worksheet . Now, if I use this way and I want to modify a field or add a new field, I need to modify all 46 sheet. Right? 

 

PS: For Access, to easy for me I love Access, but I'm online (OneDrive) and not in local network and they don't want an IT solution. I have already developed an Oracle Apex application, fully Web, perfect solution, but they want a solution updatable by an end user (No comment).  

@Francesco Cavalli 

 

hi, Is your problem solved? I am also looking for solution for such issue.

 

Thanks.