SOLVED
Home

Multiple issues with workbook being used by multiple users in realtime

%3CLINGO-SUB%20id%3D%22lingo-sub-561892%22%20slang%3D%22en-US%22%3EMultiple%20issues%20with%20workbook%20being%20used%20by%20multiple%20users%20in%20realtime%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-561892%22%20slang%3D%22en-US%22%3ESo%20we%20are%20a%20dispatching%20group%20that%20have%20access%20to%20the%20same%20workbook%20that%20updates%20and%20saves%20multiple%20users%20inputs%20in%20real-time.%20We%20are%20encountering%20many%20different%20issues%20arising%20with%20our%20workbook%20and%20we%20cannot%20fix%20but%20we%20need%20this%20sheet%20to%20run%20our%20daily%20operations.%20I%20will%20gladly%20send%20someone%20a%20copy%20of%20the%20sheet%20if%20you%20could%20help%20us...%20The%20issues%20we%20are%20running%20into%20so%20far%3A%3CBR%20%2F%3E%3CBR%20%2F%3E1)%20we%20have%20a%20master%20sheet%20at%20the%20beginning%20of%20the%20workbook%20then%20a%20sheet%20for%20each%20of%20the%20days%20of%20the%20month%20following%20behind%20the%20master.%20We%20cannot%20make%20a%20change%20to%20the%20master%20sheet%20and%20have%20that%20change%20be%20reflected%20in%20the%20sheets%20following%3CBR%20%2F%3E%3CBR%20%2F%3E2)%20In%20one%20worksheet%20are%20many%20different%20tables%20that%20hold%20information%20for%20each%20of%20the%20routes%20we%20run.%20We%20have%20a%20drop-down%20box%20with%20the%20names%20of%20each%20route%20%2F%20table%20to%20be%20able%20to%20quickly%20find%20the%20exact%20table%20we%20need%20to%20get%20to%20and%20make%20updates%20in.%20We%20have%20new%20routes%20added%20all%20the%20time%20and%20we%20need%20to%20be%20able%20to%20add%20a%20new%20table%20to%20the%20sheet%20without%20affecting%20the%20drop-down%20data%20and%20maintaining%20the%20accuracy%20of%20the%20drop%20down%20box.%3CBR%20%2F%3EThose%20are%20the%20main%20issues%20that%20we%20keep%20having%20for%20now.%20Please%20if%20anyone%20can%20help%20me%20with%20this%20it%20would%20be%20so%20greatly%20appreciated!%20As%20I%20said%20before%20I%20will%20gladly%20send%20a%20(not%20live%20of%20course)%20copy%20of%20the%20sheet%20to%20help%20u%20see%20what%20I%20am%20talking%20about%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-561892%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EUser%20Adoption%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-612646%22%20slang%3D%22en-US%22%3ERe%3A%20Multiple%20issues%20with%20workbook%20being%20used%20by%20multiple%20users%20in%20realtime%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-612646%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F341016%22%20target%3D%22_blank%22%3E%40ksbyers_0426%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20understand%20correctly%20there%20are%20some%20automations%20that%20you%20don't%20want%20anymore.%20Usually%20an%20automation%20can%20be%20switched%20off.%20You%20should%20consult%20the%20developer%20of%20the%20workbook.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-631845%22%20slang%3D%22en-US%22%3ERe%3A%20Multiple%20issues%20with%20workbook%20being%20used%20by%20multiple%20users%20in%20realtime%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-631845%22%20slang%3D%22en-US%22%3EThe%20issue%20being%20this%20has%20been%20a%20collective%20effort%20between%20different%20people%2C%20there's%20not%20any%20one%20developer%20of%20this%20workbook%20and%20the%20original%20creator%20is%20no%20longer%20around%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-632101%22%20slang%3D%22en-US%22%3ERe%3A%20Multiple%20issues%20with%20workbook%20being%20used%20by%20multiple%20users%20in%20realtime%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-632101%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F341016%22%20target%3D%22_blank%22%3E%40ksbyers_0426%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWell%2C%20then%20you%20should%20provide%20an%26nbsp%3Banonymized%20version%20of%20the%20workbook.%3C%2FP%3E%3CP%3EHowever%2C%20if%20it%20is%20a%20very%20complex%20workbook%20it%20might%20be%20better%20to%20consult%20a%20service%20provider.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
ksbyers_0426
New Contributor
So we are a dispatching group that have access to the same workbook that updates and saves multiple users inputs in real-time. We are encountering many different issues arising with our workbook and we cannot fix but we need this sheet to run our daily operations. I will gladly send someone a copy of the sheet if you could help us... The issues we are running into so far:

1) we have a master sheet at the beginning of the workbook then a sheet for each of the days of the month following behind the master. We cannot make a change to the master sheet and have that change be reflected in the sheets following

2) In one worksheet are many different tables that hold information for each of the routes we run. We have a drop-down box with the names of each route / table to be able to quickly find the exact table we need to get to and make updates in. We have new routes added all the time and we need to be able to add a new table to the sheet without affecting the drop-down data and maintaining the accuracy of the drop down box.
Those are the main issues that we keep having for now. Please if anyone can help me with this it would be so greatly appreciated! As I said before I will gladly send a (not live of course) copy of the sheet to help u see what I am talking about
3 Replies
Solution

@ksbyers_0426 

If I understand correctly there are some automations that you don't want anymore. Usually an automation can be switched off. You should consult the developer of the workbook.

 

The issue being this has been a collective effort between different people, there's not any one developer of this workbook and the original creator is no longer around

@ksbyers_0426 

Well, then you should provide an anonymized version of the workbook.

However, if it is a very complex workbook it might be better to consult a service provider.

 

 

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies