Forum Discussion
Solved
Macro enabled workbooks wont open in Excel 2016
I have a customer that has some workbooks wigth embedded macros that open in previous versions of Excel (2013 & 2010) but they wont open in 2016. Normally they hang at 0% on the Excel splashscreen, I think if you leave them for 15 mins they sometimes open.
I'm guessing there is something wrong with the VBA but I'm no expert, I have a copy of the work books is there any steps I can take to look at debugging them?
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
8 Replies
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
