.xlsm file working in Excel-2013, not working in Excel-2016

0
votes

I'am developing a tool in Excel, where I use a few macros. Around one month ago, when I tried to open the file in my Excel 2016, I got a "no response" when I enabled the macros. It was all right before that. Moreover, when this happened, all my saved files from past 3 months were not working aswell.

Does anyone have any idea, what could be the reason for that?

I use some userforms, for example one which asks for password to the file, opened by the workbook_open() sub.

1
vbaexcelexcel-2013excel-2016
You can compare the Trust Center Macro Settings on both and maybe check if one of them is 64 bit. - Slai
save as binary... try to open in 2016 and save back to xlsm - Asaf
Unfortunately, this did not help. Do you have any other ideas? - Kuba
Can you try changing your Excel settings to always allow macros without asking? If it doesn't help, try commenting out workbook_open() sub in Excel 2013, and then open with 2016, see how it works, whether it's only this one part causing malfunction. - Ryszard Jędraszyk
Use the VBA debugger to check where it is crashing. Use Breakpoints when entering your critical functions. - cyberponk

1 Answers

0
votes

I have found out, that I need to do an actualization of my excel 2016 in order to make it work. I have no idea, why it was not working, the weird part is that i have downloaded the excel 2016 in the same day, so I was expecting it to be updated. Anyway, it worked.