The source currently evaluates to an error. Do you want to continue?

BittenApple
BronzeLounger
Posts: 1498
Joined: 01 Mar 2015, 02:03

The source currently evaluates to an error. Do you want to continue?

Post by BittenApple »

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

User avatar
HansV
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?

Post by HansV »

Without seeing the workbook it is impossible to comment.
Best wishes,
Hans

BittenApple
BronzeLounger
Posts: 1498
Joined: 01 Mar 2015, 02:03

Re: The source currently evaluates to an error. Do you want to continue?

Post by BittenApple »

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