Using Excel data in other Excel files.

%3CLINGO-SUB%20id%3D%22lingo-sub-1573808%22%20slang%3D%22en-US%22%3EUsing%20Excel%20data%20in%20other%20Excel%20files.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1573808%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20my%20friends!%20I%20hope%20you%20all%20are%20safe%20and%20sound%20in%20this%20COVID-19%20madness!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%5BCONTEXT%5D%3C%2FP%3E%3CP%3EFirst%20thing%20to%20say%20is...%20i'm%20a%20new%20user%20of%20sharepoint%20and%20office%20365.%20Second%20thing%20to%20say%20is%20that%20i'm%20using%20sharepoint%20in%20my%20company%20and%20i%20have%20another%20employees%20sharing%20the%20same%20files.%3CBR%20%2F%3EThere%20is%20three%20files%20and%20them%20provide%20to%20the%20comercial%20area%20financial%20parameters%20to%20compose%20comercial%20proposal.%20But%20its%20they%20consult%20manualy%20the%20data%20from%20these%20three%20excel%20files%20in%20sharepoint.%3CBR%20%2F%3EIt's%20not%20productive%20always%20being%20consulting%20all%20the%20spreadsheets%20everytime%20they%20need%20to%20make%20a%20proposal.%3CBR%20%2F%3E%3CBR%20%2F%3E%5BQUESTION%20%2F%20HELP%5D%3CBR%20%2F%3ESo%2C%20i've%20start%20to%20seek%20some%20way%20to%20make%20the%20columns%20i%20need%2C%20from%20these%20three%20different%20excel%20files%20come%20automatically%20to%20the%20main%20excel%2C%20but%20in%20sharepoint%20i%20cant%20find%20the%20data%20options%20that%20i%20had%20in%20the%20non%20cloud%20version.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1573808%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%20Groups%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20Apps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOneDrive%20for%20Business%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1576683%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20Excel%20data%20in%20other%20Excel%20files.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1576683%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F752986%22%20target%3D%22_blank%22%3E%40vricordi%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHave%20you%20tired%20using%20the%20'Open%20in%20Desktop%20App'%20option%20%3F%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22SouravChoudhary_0-1597001869645.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F211225i864DA6D1FA05D6CD%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22SouravChoudhary_0-1597001869645.png%22%20alt%3D%22SouravChoudhary_0-1597001869645.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3ESourav%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1578147%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20Excel%20data%20in%20other%20Excel%20files.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1578147%22%20slang%3D%22en-US%22%3E%3CP%3EHey%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F754036%22%20target%3D%22_blank%22%3E%40SouravChoudhary%3C%2FA%3E%2C%26nbsp%3Btks%20for%20the%20message!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWell%2C%20i%20have%20tried%20this.%20To%20be%20more%20expecific%20i%20did%20and%20connect%20with%20sharepoint%20list%20but%20something%20went%20wrong%20and%20microsoft%20show%20me%20an%20error%20in%20the%20conection.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello my friends! I hope you all are safe and sound in this COVID-19 madness!

 

[CONTEXT]

First thing to say is... i'm a new user of sharepoint and office 365. Second thing to say is that i'm using sharepoint in my company and i have another employees sharing the same files.
There is three files and them provide to the comercial area financial parameters to compose comercial proposal. But its they consult manualy the data from these three excel files in sharepoint.
It's not productive always being consulting all the spreadsheets everytime they need to make a proposal.

[QUESTION / HELP]
So, i've start to seek some way to make the columns i need, from these three different excel files come automatically to the main excel, but in sharepoint i cant find the data options that i had in the non cloud version.

 

 

2 Replies

Hello @vricordi 

 

Have you tired using the 'Open in Desktop App' option ?

SouravChoudhary_0-1597001869645.png

 

Thanks,

Sourav

Hey @SouravChoudhary, tks for the message!

 

Well, i have tried this. To be more expecific i did and connect with sharepoint list but something went wrong and microsoft show me an error in the conection.