I just imported my GoogleSheet docs into OneDrive Sharepoint after converting them into Excel docs. Now I am looking for the equivalent of =importrange in Sharepoint/OneDrive so that I can recover data into my Dashboard from other Excel docs saved in Sharepoint. In Excel, it's easy the formula is
=[Classeur1.xlsx]X!B3 in GoogleSheet it is =importrange("5XXYxyz0xy7zzYzzz8oXYzzzYYYzzP9Yxxx6zz0zxYK9Z";"classeur1!B03"). What is the formula in Sharepoint Excel? Thank you for your help.