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
Hello Peter,
without seeing the code, it's I think difficult to delimit the error. May be, if you disable the Splash Screen, it could in a first step help. I guess, the Splash Screen is a UserForm, e.g. frmSplash. Search for the the UserForm name in the code and comment it out by putting a ' in front of the statement like frmSplash.Show. If the splash starts on opening, the statement may be in the ThisWorkbook code module. After disabling the splash screen test the file again. Does the rest then work?
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
Hello Peter,
I opened the files in Excel 2010 first. I think, I misunderstood you in your first post. I thought, you meant not the Excel Startup Screen but a Splash Screen launched by VBA. This is not the case here. There is no code running when opening the file. I am going to test it in Excel 2016 on another computer and will come back here.
Best,
Mourad