Bernkastel
New Member
- Joined
- Jun 16, 2017
- Messages
- 1
Hi all, I've been trying to solve this obscure excel problem over the past few days and can't find any documentation about it online.
I've an excel document created in Python using xlsxWriter, but for some reason the cascading dropdown list (in column C) won't display at all unless I manually use Name Manager to edit the relevant formula (such as by entering a random space after the equal sign).
I'm fairly certain that this is an excel problem, and I've attached an example of the error in the Dropbox link below.
https://www.dropbox.com/s/akn75upll2sozys/ErrorExample.xlsx?dl=0
The dropdown list in column C is set up to combine the ID in Column A with the selection in Column B, then match it to a reference sheet ("dropdown") for the relevant list.
Trying to reference the offending Named Ranges ("_ID_") for Column C under data validation results in a "source evaluates to error" message, yet I can clearly see the range the names refer to under Name Manager, so there shouldn't be a problem with the formulas for the Named Ranges.
Why in the world is the Named Range evaluating to an error when it is working fine? (I'm using Excel 2016)
I've an excel document created in Python using xlsxWriter, but for some reason the cascading dropdown list (in column C) won't display at all unless I manually use Name Manager to edit the relevant formula (such as by entering a random space after the equal sign).
I'm fairly certain that this is an excel problem, and I've attached an example of the error in the Dropbox link below.
https://www.dropbox.com/s/akn75upll2sozys/ErrorExample.xlsx?dl=0
The dropdown list in column C is set up to combine the ID in Column A with the selection in Column B, then match it to a reference sheet ("dropdown") for the relevant list.
Trying to reference the offending Named Ranges ("_ID_") for Column C under data validation results in a "source evaluates to error" message, yet I can clearly see the range the names refer to under Name Manager, so there shouldn't be a problem with the formulas for the Named Ranges.
Why in the world is the Named Range evaluating to an error when it is working fine? (I'm using Excel 2016)
