Transposing an array from another OneDrive document

Hi all,

I'm trying to transpose a table column from another workbook in excel for web, opening the documents on the desktop apps returns the required values but the web version displays #ref.

Does anyone know of a workaround for this. I've tried using get data to pull the data in from the other document first but can't get that working on the web version. I understand the web versions comes with limitations.

The formula used is

=transpose('https://d.docs.live.net/E0363ccc2ef552a6/26-27 player database.xlsx'!squad_players[player name])