Forum Discussion
Macro enabled workbooks wont open in Excel 2016
Hi Peter,
I included the changed workbooks in the zip file here. Of, course please also check the repaired versions for loss of functionality.
Note to forum moderator: I firstly tried to upload a zip file having a dot in its name, e.g. workbooks.repaired.zip. This forum then shows me the error "The contents of the attachment doesn't match its file type."
Best,
Mourad
Yeah I understand, I have attached the files to this post if anybody fancies a look.
Hello Peter,
I opened the document in Excel 2016 and I had the same problem as you. The Excel Start Screen freezes at 0%. I waited at least 5 minutes and nothing happened. After that, I terminated the process.
I decomposed the file and I saw, that your file has included a drawing with over 100 MB in uncompressed size. If I remove this drawing and let then run the AutoRepair from Excel, then the file opens in Excel 2016 without problems. So, I think the problem is the drawing (shape). I also compared both repaired and original file in Excel 2010 and did not find a difference in the sheets. So, I don't know from where the big drawing came from.
I attached the file below. I can not say, if the repaired has lost some functionality, so I recommend to verify this.
Best,
Mourad
Wow thanks, are you able to upload copies of the documnets with the drawing removed at all?
Hi Peter,
I included the changed workbooks in the zip file here. Of, course please also check the repaired versions for loss of functionality.
Note to forum moderator: I firstly tried to upload a zip file having a dot in its name, e.g. workbooks.repaired.zip. This forum then shows me the error "The contents of the attachment doesn't match its file type."
Best,
Mourad
Perfect, thank you.