Automaticaly importing one data from one Sharepoint Excel doc to another one

%3CLINGO-SUB%20id%3D%22lingo-sub-1251703%22%20slang%3D%22en-US%22%3EAutomaticaly%20importing%20one%20data%20from%20one%20Sharepoint%20Excel%20doc%20to%20another%20one%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1251703%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3EI%20just%20imported%20my%20GoogleSheet%20docs%20into%20OneDrive%20Sharepoint%20after%20converting%20them%20into%20Excel%20docs.%20Now%20I%20am%20looking%20for%20the%20equivalent%20of%26nbsp%3B%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E%3D%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3Eimportrange%20in%20Sharepoint%2FOneDrive%20so%20that%20I%20can%20recover%20data%20into%20my%20Dashboard%20from%20other%20Excel%20docs%20saved%20in%20Sharepoint.%20In%20Excel%2C%20it's%20easy%20the%20formula%20is%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E%3D%5BClasseur1.xlsx%5DX!B3%20in%20GoogleSheet%20it%20is%26nbsp%3B%3Dimportrange(%3CSPAN%20class%3D%22%20string%20%22%3E%225XXYxyz0xy7zzYzzz8oXYzzzYYYzzP9Yxxx6zz0zxYK9Z%22%3C%2FSPAN%3E%3B%3CSPAN%20class%3D%22%20string%20%22%3E%22classeur1!B03%22%3C%2FSPAN%3E).%20What%20is%20the%20formula%20in%20Sharepoint%20Excel%3F%20Thank%20you%20for%20your%20help.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1251703%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

Hi, 

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.

0 Replies