UserWarning:Discarded range with reserved name & Corrupted saved Workbook
*Created originally on Bitbucket by [ben_ceeme (Benoit)](https://bitbucket.org/%7Bdccc31fd-c21a-4dba-83ee-b8a04ac8f4a1%7D/)* I am using Anaconda 64x (Python v.2.7) and openpyxl==2.2.4 I open an xlsx file with openpyxl read_wb = openpyxl.load_workbook(z) Playing with it, cells values and formula get out just fine: so far so good. Then when I save the file I get the 'classic' discarded range with reserved name prompt (looked at the user forum of openpyxl) UserWarning: Discarded range with reserved name warnings.warn("Discarded range with reserved name") Looking at the saved file, it lost some 300k in weight compared to the original. Opening up the saved file, I get an error message that some content needs to be repaired Excel does what it can and of course the file ends up badly messed up Now I traced back the calculations down to a missing name range called 'tR' which is an empty single cell Curiously enough, I call on openpyxl to get me 'tR' properties with print read_wb.get_named_range('tR') I get: <Worksheet "Depreciation">!$A Uhm, no figure, no number, just !$A So then I unzipped the .xlsx, went into \xl\workbook.xml to check it out: <definedName name="tR" localSheetId="3">Depreciation!$A1</definedName> Then the name manager in Excel tells me that tR refers to Depreciation!$A7 !!!! So it seems that something low level overrides the instruction of workbook.xml, but despite looking at all the xml files one by one I cannot figure out what...
issue