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

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

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,101,905
Messages
5,483,653
Members
407,399
Latest member
Rakeforms

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top