Creating interactive workbook

%3CLINGO-SUB%20id%3D%22lingo-sub-2026816%22%20slang%3D%22en-US%22%3ECreating%20interactive%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2026816%22%20slang%3D%22en-US%22%3E%3CP%3EHappy%20new%20year%20everyone!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20I'm%20new%20on%20participating%20on%20this%20%22Discussions%22%20and%20I'm%20looking%20for%20help%20or%20guidance%20(in%20case%20this%20issue%20was%20put%20before)%3C%2FP%3E%3CP%3EI'd%20like%20to%20thank%20you%20in%20advance%20for%20any%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20shared%20workbook%20wich%20is%20used%20by%20at%20least%202%20people%20permanently%20and%20is%20needed%20to%20be%20consulted%20and%20sometimes%20has%20to%20be%20edited%20in%20order%20to%20add%20more%20information%2C%20by%20other%20people%20in%20different%20computers%2C%20in%20realtime%20as%20we%20work%20on%20it.%3C%2FP%3E%3CP%3ESo%20far%2C%20we%20are%20working%20on%20it%20as%20shared%20and%20protected%20(with%20read-write%20password)%20and%20here%20is%20where%20the%20problem%20starts.%20Sometimes%2C%20to%20take%20away%20some%20work%20from%20those%202%20guys%20told%20before%2C%20the%20other%20people%2C%20who%20need%20to%20add%20information%20to%20the%20workbook%2C%20open%20it%20and%20as%20our%20network%20sometimes%20has%20some%20issues%20the%20work%20start%20to%20show%20some%20errors%20and%20don't%20let%20people%20save%20the%20work%20progress%20making%20us%20to%20force%20close%20the%20excel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20I'm%20looking%20for%20is%20a%20way%20to%20project%20the%20information%20while%20I'm%20working%20on%20the%20workbook%20and%20people%20can%20consult%2C%20without%20open%20the%20same%20file%20as%20me%2C%20AND%20could%20edit%20some%20%22tick%20boxes%22%20where%20I%20could%20see%2C%20on%20my%20workbook%2C%20the%20task%20is%20done.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDo%20you%20know%20any%20way%20this%20could%20be%20made%3F%3C%2FP%3E%3CP%3EIs%20it%20possible%20to%20have%202%20(equal)%20workbooks%2C%20connected%20to%20each%20other%20(via%20macros%20maybe%3F%3F%3F)%20where%20in%20one%20part%20I%20have%20the%20cells%20where%20I%20shall%20introduce%20information%20and%20on%20the%20other%20part%20I%20have%20the%20cells%20where%20I%20should%20read%20the%20information%20imported%20from%20the%20other%20workbook%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20Office%202019.%3C%2FP%3E%3CP%3EIt's%20kinda%20confusing%20but%20can't%20explain%20it%20better%20%3CLI-EMOJI%20id%3D%22lia_confused-face%22%20title%3D%22%3Aconfused_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20regards%2C%3C%2FP%3E%3CP%3ELFDiniz%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2026816%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Happy new year everyone!

 

So I'm new on participating on this "Discussions" and I'm looking for help or guidance (in case this issue was put before)

I'd like to thank you in advance for any help.

 

I have a shared workbook wich is used by at least 2 people permanently and is needed to be consulted and sometimes has to be edited in order to add more information, by other people in different computers, in realtime as we work on it.

So far, we are working on it as shared and protected (with read-write password) and here is where the problem starts. Sometimes, to take away some work from those 2 guys told before, the other people, who need to add information to the workbook, open it and as our network sometimes has some issues the work start to show some errors and don't let people save the work progress making us to force close the excel.

 

What I'm looking for is a way to project the information while I'm working on the workbook and people can consult, without open the same file as me, AND could edit some "tick boxes" where I could see, on my workbook, the task is done.

 

Do you know any way this could be made?

Is it possible to have 2 (equal) workbooks, connected to each other (via macros maybe???) where in one part I have the cells where I shall introduce information and on the other part I have the cells where I should read the information imported from the other workbook?

 

I have Office 2019.

It's kinda confusing but can't explain it better

 

Best regards,

LFDiniz

0 Replies