Issues Opening Workbook in Excel 2016 with macros
Results 1 to 3 of 3

Thread: Issues Opening Workbook in Excel 2016 with macros
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Feb 2004
    Posts
    351
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Issues Opening Workbook in Excel 2016 with macros

    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.

  2. #2
    Board Regular
    Join Date
    May 2017
    Posts
    469
    Post Thanks / Like
    Mentioned
    5 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Issues Opening Workbook in Excel 2016 with macros

    There should not be any issue opening older macro enabled workbooks with Excel 2016. How old are these workbooks?

  3. #3
    Board Regular
    Join Date
    Feb 2004
    Posts
    351
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Issues Opening Workbook in Excel 2016 with macros

    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.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •