Changes from EXCEL 2016 to 365

I have several tables in 3 diferent files, in  2 computer. I have joined such tables using a fomula (  "=IF(ISERROR(MATCH($A12;'\\OFICINA\scan\Requisiciones Tarachi\OC Para Firma\[Purchase-order-tracker-vendors Tarachi.xlsm]Orders'!$A:$A;0));"";IF(INDEX('\\OFICINA\scan\Requisiciones Tarachi\OC Para Firma\[Purchase-order-tracker-vendors Tarachi.xlsm]Orders'!F:F;MATCH($A12;'\\OFICINA\scan\Requisiciones Tarachi\OC Para Firma\[Purchase-order-tracker-vendors Tarachi.xlsm]Orders'!$A:$A;0))="";"";INDEX('\\OFICINA\scan\Requisiciones Tarachi\OC Para Firma\[Purchase-order-tracker-vendors Tarachi.xlsm]Orders'!F:F;MATCH($A12;'\\OFICINA\scan\Requisiciones Tarachi\OC Para Firma\[Purchase-order-tracker-vendors Tarachi.xlsm]Orders'!$A:$A;0))))  ")

where it takes one value and retreives the value on the designated colum from the reffered location/file/sheet. this formula worked perfectly on EXCEL 2016, now company updated to OFFICE 365 and it does not updates properly, I Even the ones i have on my regula tables, to complete a report from anoder file, do not update properly. Is there a change in the process?? I need the to continue update and to be able to read it even with a file closed, as I was doing. Any assistence is welcome. 

In addition I have this VB code that runs at the opening of one of the files to update a table and it only retreives the first value of the first colum (there are 5 colums with over 1,000 rows).

Application.ScreenUpdating = False
Dim lst As Integer
Sheets("Hoja4").Select
Range("CH1").Select

ActiveCell.FormulaR1C1 = _
"='\\OFICINA\scan\PO para firma\[purchase-order-tracker-vendors.xlsm]Inventario'!R[]C"
Range("CH1").Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False

          (the prior brings the last row of the table i want to bring to be asigned to variable lst)

lst = Range("CH1").Value + 1
Range("A2").Select
ActiveCell.FormulaR1C1 = _
"='\\OFICINA\scan\PO para firma\[purchase-order-tracker-vendors.xlsm]Inventario'!R[1]C"
Range("A2").Select
Selection.AutoFill Destination:=Range("A2:G2"), Type:=xlFillDefault
Range("A2:G2").Select
Selection.AutoFill Destination:=Range("A2:G" & lst)
Range("A2:G" & lst).Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False

It brought a table from a closed file in another computer, now only the first value, and the rest os all "0"