Home

Get information and change source data

%3CLINGO-SUB%20id%3D%22lingo-sub-614013%22%20slang%3D%22en-US%22%3EGet%20information%20and%20change%20source%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-614013%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20information%20in%20a%20sheet%20in%20Excel%20file%20in%20Office%202010%20version%20and%20I'm%20trying%20to%20access%20from%20another%20Excel%20file%20in%20Office%20365%20version.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20used%20option%20%3CEM%3Edata%3C%2FEM%3E%20--%26gt%3B%20%3CEM%3Eget%20information%3C%2FEM%3E%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20298px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F114301iA02653AD8B956947%2Fimage-dimensions%2F298x82%3Fv%3D1.0%22%20width%3D%22298%22%20height%3D%2282%22%20alt%3D%22datos-obtener%20informaci%C3%B3n.png%22%20title%3D%22datos-obtener%20informaci%C3%B3n.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3Eand%20it's%20OK%20reading%20information%2C%20but%20I%20need%20update%20this%20information%20too%2C%20not%20only%20read%20the%20information%20I%20want%20to%20update%20this%20information%20and%20I%20don't%20find%20the%20correct%20option.%3C%2FP%3E%3CP%3EIf%20it%20was%20SQL%2C%20I%20have%20a%20SELECT%20operation%20and%20I%20need%20a%20UPDATE%20operation%2C%20is%20it%20possible%20to%20do%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20very%20much.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-614013%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-614054%22%20slang%3D%22en-US%22%3ERe%3A%20Get%20information%20and%20change%20source%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-614054%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F344643%22%20target%3D%22_blank%22%3E%40EstebanGaleano%3C%2FA%3E%26nbsp%3B%2C%20nope%2C%20in%20Get%20%26amp%3B%20Transform%20there%20is%20no%20such%20option%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-614055%22%20slang%3D%22en-US%22%3ERe%3A%20Get%20information%20and%20change%20source%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-614055%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F344643%22%20target%3D%22_blank%22%3E%40EstebanGaleano%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EClick%20on%20%22Actualizar%20todo%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
EstebanGaleano
Occasional Visitor

 

 

I have information in a sheet in Excel file in Office 2010 version and I'm trying to access from another Excel file in Office 365 version.

 

I have used option data --> get information:

datos-obtener información.png

and it's OK reading information, but I need update this information too, not only read the information I want to update this information and I don't find the correct option.

If it was SQL, I have a SELECT operation and I need a UPDATE operation, is it possible to do?

 

Thank you very much.

2 Replies
Highlighted

@EstebanGaleano , nope, in Get & Transform there is no such option

@EstebanGaleano 

Click on "Actualizar todo".

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies