Excel连接SharePoint报错Could not find installable ISAM求排查方案

我们为客户制作了一个可连接SharePoint的Excel文件，该文件在我方设备及客户虚拟机上均可正常运行，但在客户的笔记本电脑上触发以下错误：

Could not find installable ISAM

相关VBA代码 #

连接SharePoint的代码 #

Sub executeSQLList(sql As String, list As String)
    Dim conn As Object
    Dim connString As String

    connString = "Provider=Microsoft.ACE.OLEDB.12.0;WSS;IMEX=0;RetrieveIds=Yes;DATABASE=https://mysite;LIST=" & list & ";"

    Set conn = CreateObject("ADODB.Connection")
    conn.Open connString
    conn.Execute sql
    conn.Close

    Set conn = Nothing
    Application.ScreenUpdating = False
End Sub

已完成的排查 #

• 确认SharePoint权限无异常
• 本地连接Excel的VBA代码可正常运行，代码如下：

Function ConnectToExcelSheet(sql_query As String) As Object
    Dim conn As New ADODB.CONNECTION
    Dim rs As New ADODB.Recordset
    Dim connString As String
    
    rs.CursorLocation = adUseServer
    
    connString = "Provider=Microsoft.ACE.OLEDB.12.0;" & _
                 "Data Source=" & ThisWorkbook.FullName & ";" & _
                 "Extended Properties='Excel 12.0 Macro;HDR=YES'"
    
    conn.Open connString
    rs.Open sql_query, conn  
    Set ConnectToExcelSheet = rs
    Application.ScreenUpdating = False
End Function

目前怀疑问题由Excel版本差异导致，寻求该错误的解决方案。

内容的提问来源于stack exchange，提问作者Hotta