Hi all, I have a.xlsm file template (containing macros) which I load (with keepvba=True) and populate with openpyxl (v2.1.4), then I save it as a new file. When opening the populated file in MS Excel 2013, it throws an error saying: 'We found a problem with some content in 'filename.xlsm'. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes.' (Options: Yes, No) After repairing the file, Excel shows a dialog with title 'Repairs to 'filename.xlsm' and the following content: Info: 'Excel was able to open the file by repairing or removing the unreadable content.'

Text field: 'Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded.' There is also a link to the log file (XML), but no extra info is given there. However, it does not seem that the error breaks anything in the file - all the macros, formatting are not affected. The only problem is that the Excel needs to repair something in the file saved by openpyxl. Could you please help solving this issue? Regards, Andrius.

Error Opening Windows .xlsm File In Excel 2016 For Mac

The file I use is very small and the macros are pretty simple. The generated file cannot be opened with the OpenXML Productivity Tool: 'Cannot open the file: Required Types tag not found.

Line 1, position 2.' Anyway, I've found a problem. In ContentTypes.xml there are lines describing some kind of external link after definition of each sheet (in my case I have two sheets so this line is repeated twice in the file): The content of that file: After removing the two lines (also externalLinks folder) referencing this file, the XLSM file opens without error. Hi all, I've the similiar problem with xlsm file.

I can open it with excel 2016 on Win 7 but i can't open on windows 10. I'd already checked region settings between 7 and 10. They're same. When i choose 'to recover as much as we can?'

The records are repaired with this message 'Repaired Records: Format from /xl/styles.xml part (Styles)' the log is ' - error02056001.xml Errors were detected in file 'C: Users serife.yilmaz Desktop 34 Hafta nakit planlama.xlsm' - Repaired Records: Format from /xl/styles.xml part (Styles) ' the data format is not right in the cells after repair. For example it has to be '8.905.696' but it is '.914' how i can fix it? Thank you.