Pull data from another excel document
I have 2 excel documents (not work sheets). ABC.xls, PQR.xls and XYZ.xls.
I want to automatically pull the data from ABC and PQR to XYZ. Is there any way?
All three documents are saved in same share point location in my computer.
Unfortunately, i cannot make it as multiple sheets in same document.
Can it be done by Power BI?
I have 2 excel documents (not work sheets). ABC.xls, PQR.xls and XYZ.xls. I want to automatically pull the data from ABC and PQR to XYZ. Is there any way?All three documents are saved in same share point location in my computer.Unfortunately, i cannot make it as multiple sheets in same document. Can it be done by Power BI? Read More