Issue with .xlsm synchonized with Sharepoint
Created originally on Bitbucket by Eric Mathieu
I have a small script writing data in an Excel file using openpyxl. Everything is working fine with .xlsx and .xlsm (keep_vba=True
) files when they are in a standard folder. When they are in a folder that is synchronized with a Sharepoint server the updated .xlsm, Excel throw a message on opening telling that my file cannot be saved since my modifications cannot be merged by the ones performed by someone else using a previous version of Excel (approximate translation from french) and I cannot use that file. If I the copy it to a standard folder it open fine and I can save it. If I then copy it back to the synchronized folder I can then open it.
The issue do not affect .xlsx file (load_workbook with out keep_vba=True
)