openpyxl workbook.save() corrupts simple xlsx workbook with external link

Question

I have a simple Excel xlsx file with one sheet and one external link which becomes corrupted if I open it and save it with openpyxl.

This is a question similar to others (here and here and elsewhere). However, my example does not contain complicated excel features like charts / images / macros. And my example is not solved by different versions of openpyxl. I have tested these versions of openpyxl:

3.0.3
2.4
3.1.1
3.1.2

I have a simple Excel file with one sheet. It has one formula which is a link to another workbook. The formula is:

='C:\Temp\temp\[Book2.xlsx]Sheet1'!$A$3

Now I run the simple program:

def main():
    f1="C:/Temp/temp/Book1.xlsx"
    print(openpyxl.__version__)
    wb=openpyxl.load_workbook(filename=f1)
    wb.save(f1)
    wb.close()

After I run this the file becomes corrupted:

If I allow Excel to attempt to recover the file, the external link appears as: =[RecoveredExternalLink1]Sheet1!$A$3

I can update this link to the original file and no other corruption appears to have occurred.

This problem seems to have happened recently. Similar code I have been using for over a year has started to produce this issue in the last couple of months. My version of Excel (64 bit) is:

openpyxl workbook.save() corrupts simple xlsx workbook with external link

0 Answers0