Hi, I came to this forum looking for some help after I watched a video on dependant drop down menu alternatives.

I have this downtime sheet that I've stripped down.  It's part of a much larger workbook.  The issue is this sheet is extremely slow to process.  The drop down menus have visual delay with a "thinking wheel" before the menu is presented.  After researching, I'm sure it's the indirect usage in the data validation.  I have about 2000 rows in the normal sheet.  There is also a large name manager setup too.

Is there a way to fix this or convert what I have into a newer alternative to make things run normal?  I watched the video but I'm not confident I follow what was shared.  This workbook is on sharepoint and there could be a handful of users on this workbook interacting at any one time.  The users could be using desktop excel or online excel.

I tried to attach a sample file but I get an error.

Thanks for the feedback.