.xlsm files won't open, Excel 2016 stops working.

[mmacdougall]

We have some .xlsm files we use at the office. All of a sudden when we try to open them, Excel stops working and won't open. It then places the file we tried to open on the disabled list. I've tried it now on 4 users machines and it's doing it for all of them. I imagine it's because of an update, just not sure what to do as we use these .xlsm files for each project.

We are using Excel 2016

 

[mmacdougall]

After the crash, I get this.

Problem signature:
Problem Event Name: BEX
Application Name: EXCEL.EXE
Application Version: 16.0.8067.2115
Application Timestamp: 5918bd78
Fault Module Name: MSVCR100.dll
Fault Module Version: 10.0.40219.325
Fault Module Timestamp: 4d5f0c22
Exception Offset: 0008af3e
Exception Code: c0000417
Exception Data: 00000000
OS Version: 6.1.7601.2.1.0.256.48
Locale ID: 4105

Additional information about the problem:
LCID: 1033
skulcid: 1033

Read our privacy statement online:
http://go.microsoft.com/fwlink/?linkid=104288&clcid=0x0409

If the online privacy statement is not available, please read our privacy statement offline:
C:\Windows\system32\en-US\erofflps.txt

 

[Sektor]

Is there any chance you could upload it to some cloud storage?

 

[mmacdougall]

Here you go, its on onedrive. https://1drv.ms/x/s!AtjqpJojJmetgQNX4Iv2T6BpWQ5u

We are using Office home and business 2016. Fully updated. Version 1704 Build 8067.2115 click to run

We use this file as a template for every job we do. As of a few days ago, this template has stopped working, as well as each saved file per job. 100's. Im sure its an update causing it, but we really need to be able to get into our old macro enabled files.

Thanks

 

[Sektor]

For my Office 2010 this workbook opens OK. You're using some component (which isn't available on my machine) - perhaps, it causes error. Also try to disable any add-ins.
As a side note, your Sub UNHIDE could be narrowed to one line: Columns("F:O").EntireColumn.Hidden = False. Also CheckBox124_Click logic could be simplified too: Columns("F").EntireColumn.Hidden = Not Range("F3").Value.

 

[Sektor]

Also for simplifying creating SQL queries you could use the following FormatString helper function. The usage example is also provided:

Sub TestFormatString()
    MsgBox FormatString("I have {0} apples and {1} bananas", 10, 20)
End Sub


Function FormatString(str As String, ParamArray args()) As String
    Dim s As String, x As Integer
    s = str
    For x = UBound(args) To 0 Step -1
        s = Replace$(s, "{" & x & "}", args(x))
    Next
    FormatString = s
End Function

 

[mmacdougall]

The issue is, it worked before an office update. We have hundreds of these spreadsheets, I wont be able to make any changes to them. Some are 10 years old.

 

[sedgefield02]

Having the same problem

 

[mmacdougall]

As soon as I uninstall the Office update, I can open them again.

This is a temp fix, but at some point I will have to get Office updated and current.

 

[sedgefield02]

I have vba code developed on windows 7. I have been able to move it to my windows 10 machine simply by copying the xlm file to a thumb rive and the coying the file to the windows 10 machine. This establishes a desktop icon with the file name "Bova1". When I click the desktop icon excel starts to load but stops at about 72%. The file is placed in disabled status.

I have a work around but it is cumbersome.

1. click on the excel icon to start excel with no code loaded
2. select blank sheet from file
3. clear the file from disabled status (File, options, add ins, manage,go etc)
4. From file click the name of the file "Bova1" and it loads and executes

Any help would be appreciated