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

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

Highlighted

@EstebanGaleano 

Click on "Actualizar todo".

 

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