*Created originally on Bitbucket by [Kirill Marchuk](https://bitbucket.org/%7Bc947cc7c-85bb-4017-a110-74a46b7fdb2c%7D/)* Hi all Windows 10, openpyxl 2.3.2 I've got an Excel .xlsx file from our VoIP provider, and I cannot parse it using pyexcel-xlsx due to this exception: File "C:\Python27\lib\site-packages\openpyxl\workbook\names\external.py", line 83, in parse_ranges names = book.find('{%s}definedNames' % SHEET_MAIN_NS) AttributeError: 'NoneType' object has no attribute 'find' This is a place where it happens: ``` #!python def parse_ranges(xml): tree = fromstring(xml) book = tree.find('{%s}externalBook' % SHEET_MAIN_NS) names = book.find('{%s}definedNames' % SHEET_MAIN_NS) ``` the "xml" parameter is as follows: <?xml version="1.0" encoding="UTF-8" standalone="yes"?> <externalLink xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" mc:Ignorable="x14" xmlns:x14="http://schemas.microsoft.com/office/spreadsheetml/2009/9/main"><oleLink xmlns:r="http://schemas.openxmlformats.org/office Document/2006/relationships" r:id="rId1" progId="Word.Document.12"><oleItems><oleItem name="!OLE_LINK1" advise="1" preferPic="1"/></oleItems></oleLink> </externalLink> apparently, there's not "externalBook" element, so book is set to None and this condition is not checked in the code Would you say it's a bug or just faulty Workbook ? It works in Excel, otherwise, with a warning about invalid external links. If I remove links from file, it's processed fine with openpyxl *Attachments:* [your_data_wrong_empty.xlsx](/uploads/ef630b6119828026af108ae9675c1c2b/your_data_wrong_empty.xlsx)