External data from WEB error

[shahzeb123]

Hey guys !

need a little help if u can manage.

The thing is I have made a sheet where it collects data from web , (4 data table from web).

and it is working great on my system.

But when I shared the file with my colleague who uses the same network everything is same.

However, sheet is not getting refreshed I have made a button with below code

ActiveWorkbook.RefreshAll
MsgBox "Update Complete"
Range("A1") = Date & "-" & Time

if there is any way I can share the sheet with you guys, being in professional org. i cant download any software or extension. I can provide the sheet on gmail .

 

[shahzeb123]

Moreover, if i refresh all table one by one it works on other system as well.

But refresh all is not working.