Issues Opening Workbook in Excel 2016 with macros

rki1966

Active Member
Joined
Feb 1, 2004
Messages
351
We recently upgraded to excel 2016 and when I try to open my workbooks with macros they try to open then close. If I open another workbook or blank workbook then open the workbook with the macro, I do not have any issues. If I did try to open the workbook with the macro first, then opened a blank one it would show the one with the macro in repaired mode.

I want to points out that it happens to .xlsb and .xlsm files.
 

Some videos you may like

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

rlv01

Well-known Member
Joined
May 16, 2017
Messages
771
There should not be any issue opening older macro enabled workbooks with Excel 2016. How old are these workbooks?
 

rki1966

Active Member
Joined
Feb 1, 2004
Messages
351
Some of the workbooks are new and others were created in 2010. I ran a couple more test.

1. Saved the workbook on my desktop and open it from Excel ( Same issue)
2. Opened the workbook on my desktop from Windows Explorer (No problem)
3. Opened the workbook on the shared drive from Windows Explorer (No problem)

It looks the only time I have a problem is when I open it from excel when no other workbooks are open.
 

Watch MrExcel Video

Forum statistics

Threads
1,102,435
Messages
5,486,869
Members
407,567
Latest member
spinitback

This Week's Hot Topics

Top