Hello team,
I have 3 dependent dropdowns and I get this message on the last dropdown when I go to data validation for third dropdown.
What is causing to get that error message?
Regards,
Bita
The source currently evaluates to an error. Do you want to continue?
-
- BronzeLounger
- Posts: 1498
- Joined: 01 Mar 2015, 02:03
-
- Administrator
- Posts: 78237
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: The source currently evaluates to an error. Do you want to continue?
Without seeing the workbook it is impossible to comment.
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1498
- Joined: 01 Mar 2015, 02:03
Re: The source currently evaluates to an error. Do you want to continue?
Hello Hans,
I found it. One of the entries has two spaces in a two part name; replacing one space with a dash couldn't take care of this because there was two spaces.
Regards,
Bita
I found it. One of the entries has two spaces in a two part name; replacing one space with a dash couldn't take care of this because there was two spaces.
Regards,
Bita