A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Dependent Drop-down List Partially Working
Hi,
I've created a dependent drop-down list. The five columns of data are below. The top row contains the main ddl and the values underneath the resulting values in the dependent ddl. It works as designed for all columns except for column 2. When I select 2D Animation from the main ddl, I am unable to open the dependent ddl to select a value. Any thoughts appreciated.
| eLearning | 2D Animation | PPT | Video | Pick One | |||
|---|---|---|---|---|---|---|---|
| Pick One | Pick One | Pick One | Pick One | Pick One | |||
| Slide-based | Animation + Role Play | Slide addition and update | Video Edit (Addition and Update Clips) per clip of 1 min | ||||
| Slide + External animation | Animation + Role Play + Scenario | Slides Branding from existing material | Video - Audio edit | ||||
| Animation | Animation + White Board | Recreate Slides from Static Files | Adding Background Score | ||||
| Slide + simulations | PDF to PPT | Adding Subtitles (define & add) | |||||
| Slides + Sims +Animation | Word To PPT | Video with 2D Animation (Per Animation 1 min) | |||||
| Slide + Role Play | New PPT creation with PTW Branding | Adding Video credits | |||||
| Slide + Scenario + Role Play | Storyboard | Video Creation (from scratch Per clip of 1 min) | |||||
| Slide with basic animation | video creation + Localization to multiple languages | ||||||
| Slides with instructor transcript | Webinar coverage video (Per clip of 1 min) | ||||||
| Slides with Audio Transcript | Product launch video edits (Per clip of 1 min) | ||||||
| Video morphing (from scratch Per clip of 1 min) | |||||||
| Adding video transitions |
Microsoft 365 and Office | Excel | For business | Windows
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.