Named cells (constants) do not work
Created originally on Bitbucket by Anonymous
openpyxl treats all named elements as named ranges, and does not allow for "constants", as created in excel the following way:
Use the Insert->Name->Define dialog to define a name "MyNum" which has some value (e.g. 30). To enter the value in the "Refers To" box, type: =80