I'm using ListObject in Excel's VBA to get a list from SharePoint so I'm able to view it in Excel and add new items from Excel. The only problem is that the SharePoint List has a column which accepts multiple lookup values connected to another SharePoint List. This column is not shown in Excel when I run the VBA code.
Dim objList As ListObject
Dim strSPServer As String
Const SERVER As String = "https://<SharepointUrl>"
Const LISTNAME As String = "ListName"
Const VIEWNAME As String = ""
strSPServer = SERVER & "_vti_bin"
Set objWs = ActiveSheet
Set objList = objWs.ListObjects.Add(xlSrcExternal, Array(strSPServer, LISTNAME, VIEWNAME), True, xlYes, Range("A1"))
Set objList = Nothing
Set objWs = Nothing
Is there a solution to this problem?