Error in three-level dependent list

Question

I have set up a three-level dependent list in a table. It all works fine to the last row selected (263). Problem arises when starting a new row. Dropdown list only appears in the first level. Second and third do not have the drop-down button.
I have tried to overcome this issue by extending the selection to the whole three columns, but it never stops processing and blocks Excel.

Any suggetion?

Amanda Lee · Accepted Answer

Hi there,

We've checked the file you sent, we noticed that you didn't expand the dynamic drop-down list range. Which means the range you applied the feature is $H$2:$J$263. To expand the range, please do as follows:

1. On the Kutools tab, click Navigation. And then click on the icon circled in red as shown below to unhide the hidden worksheets.

2. Delete List and List1 as shown below.

3. Go back to RECIBIDAS sheet. Click on any cell that is in the range $H$2:$J$263, and then click Expand Dynamic Drop-down List Range.

4. An Output Range dialog pops up, now select the new range where you want to have the drop-down list. The new range will be filled in the box. Alternatively, you can type in the range directly in the input box, for example, $H$2:$J$300.

5. Click OK.

The drop-list is now applied in the new expanded range. If there are any other problems, please don't hesitate to ask me.

Amanda