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
- Hi Mourad,
I reviewed this post as I am having issues opening a macro enabled workbook in excel 2016. My issue is I created this workbook using excel 2016. I'll put in the VBA code and everything will work fine. When I save it I receive a prompt for macro enabled workbook and I change the file type to do so, but once I close out of the file and re-open it, the VBA codes do not work properly. As an example, I created a drop down list with multiple selections. It will work when I put the code in, but once I save and re-open I cannot make multiple selections from the drop down list. 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?
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
