Refresh the XML Mapping of a Folder

%3CLINGO-SUB%20id%3D%22lingo-sub-2192651%22%20slang%3D%22en-US%22%3ERefresh%20the%20XML%20Mapping%20of%20a%20Folder%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2192651%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECurrently%20I%20have%20a%20mapped%20table%20where%20all%20my%20XML%20forms%20are%20gathered%2C%20however%20I%20would%20like%20Excel%20to%20automatically%20import%20this%20data%20to%20me%20without%20having%20to%20click%20on%20the%20%22import%22%20click.%3C%2FP%3E%3CP%3EIs%20it%20then%20possible%20to%20update%20an%20XML%20mapping%20without%20necessarily%20importing%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance%20for%20your%20feedback%2C%3C%2FP%3E%3CP%3Ecordially%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERemy%20DARQUES%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2192651%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2192986%22%20slang%3D%22de-DE%22%3ESubject%3A%20Refresh%20the%20XML%20Mapping%20of%20a%20Folder%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2192986%22%20slang%3D%22de-DE%22%3EImport%20XML%20Files%20into%20Excel%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fwww.howtoexcel.org%2Fpower-query%2Fimport-xml-files%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.howtoexcel.org%2Fpower-query%2Fimport-xml-files%2F%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EJust%20an%20info%20to%20help%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2193175%22%20slang%3D%22fr-FR%22%3EBetreff%3A%20Refresh%20the%20XML%20Mapping%20of%20a%20Folder%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2193175%22%20slang%3D%22fr-FR%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40Nikolino%3C%2FA%3Ethank%20you%20for%20your%20answer.%3C%2FP%3E%3CP%3EHowever%20it%20seems%20to%20me%20that%20this%20import%20method%20via%20Power%20Query%20only%20allows%20you%20to%20select%20a%20single%20XML%20file%20while%20my%20objective%20would%20be%20to%20bring%20all%20my%20new%20XML%20files%20back%20to%20my%20table%20from%20an%20actualization.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2193222%22%20slang%3D%22en-US%22%3EBetreff%3A%20Refresh%20the%20XML%20Mapping%20of%20a%20Folder%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2193222%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F938649%22%20target%3D%22_blank%22%3E%40Remi131765%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fimport-xml-data-6eca3906-d6c9-4f0d-b911-c736da817fa4%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EOther%20ways%20to%20import%20XML%20data%3C%2FA%3E%3C%2FP%3E%3CUL%3E%3CLI%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fimport-xml-data-6eca3906-d6c9-4f0d-b911-c736da817fa4%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%23bmimport_an_xml_file_as_an_xml_list_wit%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EImport%20an%20XML%20data%20file%20as%20an%20XML%20table%3C%2FA%3E%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fimport-xml-data-6eca3906-d6c9-4f0d-b911-c736da817fa4%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%23bmimport_multiple_xml_files_into_one_or%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EImport%20multiple%20XML%20data%20files%3C%2FA%3E%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fimport-xml-data-6eca3906-d6c9-4f0d-b911-c736da817fa4%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%23bmimport_an_xml_file_as_external_data_w%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EImport%20multiple%20XML%20data%20files%20as%20external%20data%3C%2FA%3E%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fimport-xml-data-6eca3906-d6c9-4f0d-b911-c736da817fa4%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%23bmopen_an_xml_data_file%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EOpen%20an%20XML%20data%20file%20to%20import%20its%20data%3C%2FA%3E%3C%2FP%3E%3C%2FLI%3E%3C%2FUL%3E%3CP%3EFor%20more%20information%20about%20issues%2C%20see%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fimport-xml-data-6eca3906-d6c9-4f0d-b911-c736da817fa4%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%23bmissues%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ECommon%20issues%20with%20importing%20XML%20data%3C%2FA%3E%20at%20the%20end%20of%20this%20article.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2210765%22%20slang%3D%22fr-FR%22%3EBetreff%3A%20Refresh%20the%20XML%20Mapping%20of%20a%20Folder%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2210765%22%20slang%3D%22fr-FR%22%3EHello%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40NikolinoDE%3C%2FA%3E%2C%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Thanks%20for%20your%20answer%20but%20we%20don't%20know%20how%20it%20is%20possible%20to%20refresh%20an%20XML%20file%20folder%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Remi%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2211061%22%20slang%3D%22en-US%22%3EBetreff%3A%20Refresh%20the%20XML%20Mapping%20of%20a%20Folder%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2211061%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F938649%22%20target%3D%22_blank%22%3E%40Remi131765%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Frefresh-an-external-data-connection-in-excel-1524175f-777a-48fc-8fc7-c8514b984440%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3ERefresh%20an%20external%20data%20connection%20in%20Excel%3C%2FA%3E%3C%2FP%3E%3CP%20class%3D%22x-hidden-focus%22%3EYou%20can%20keep%20the%20data%20in%20your%20workbook%20up%20to%20date%20by%20%22refreshing%22%20the%20link%20to%20its%20source.%20Each%20time%20you%20refresh%20the%20connection%2C%20you%20see%20the%20most%20recent%20data%2C%20including%20anything%20that's%20new%20or%20has%20been%20deleted.%3C%2FP%3E%3CDIV%20class%3D%22ocpAlert%22%3E%3CP%20class%3D%22ocpAlertSection%20x-hidden-focus%22%3E%3CSTRONG%3ESecurity%20Note%3A%3C%2FSTRONG%3E%26nbsp%3BConnections%20to%20external%20data%20may%20be%20currently%20disabled%20on%20your%20computer.%20To%20refresh%20the%20data%20when%20you%20open%20a%20workbook%2C%20you%20must%20enable%20the%20data%20connections%20by%20using%20the%20Trust%20Center%20bar%2C%20or%20you%20must%20place%20the%20workbook%20in%20a%20trusted%20location.%20For%20more%20information%2C%20see%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fadd-remove-or-change-a-trusted-location-7ee1cdc2-483e-4cbb-bcb3-4e7c67147fb4%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EAdd%2C%20remove%2C%20or%20modify%20a%20trusted%20location%20for%20your%20files%3C%2FA%3E%2C%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fadd-remove-or-view-a-trusted-publisher-87b3d5a3-b68c-4023-87c4-7cc78a44d7ed%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EAdd%2C%20remove%2C%20or%20view%20a%20trusted%20publisher%3C%2FA%3E%2C%20and%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fview-my-privacy-options-in-the-microsoft-office-trust-center-d672876e-20d3-4ad3-a178-343d044e05c8%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EView%20my%20options%20and%20settings%20in%20the%20Trust%20Center%3C%2FA%3E.%3C%2FP%3E%3CP%20class%3D%22ocpAlertSection%20x-hidden-focus%22%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EClick%20the%20heading%20for%20more%20information%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2250678%22%20slang%3D%22fr-FR%22%3EBetreff%3A%20Refresh%20the%20XML%20Mapping%20of%20a%20Folder%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2250678%22%20slang%3D%22fr-FR%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40NikolinoDE%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EFirst%20of%20all%20I'm%20sorry%20for%20the%20response%20time.%20I%20have%20consulted%20your%20links%20and%20everything%20seems%20ok%20to%20me%2C%20however%20I%20cannot%20update%20(see%20the%20photo).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tell%20myself%20that%20maybe%20the%20problem%20comes%20from%20my%20files%20because%20they%20are%20in%20.xdp%20format%20and%20not%20.xml%20as%20Excel%20would%20like.%3C%2FP%3E%3CP%3EIn%20this%20case%2C%20is%20it%20not%20possible%20to%20obtain%20data%20from%20a%20Folder%20that%20only%20takes%20into%20account%20.xdp%20files%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Remi131765_0-1617360365277.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F269101i9C4CA8632BB04BBD%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Remi131765_0-1617360365277.png%22%20alt%3D%22Remi131765_0-1617360365277.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3CP%3ELooks%3C%2FP%3E%3CP%3ER%C3%A9mi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2678371%22%20slang%3D%22en-US%22%3ERe%3A%20Refresh%20the%20XML%20Mapping%20of%20a%20Folder%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2678371%22%20slang%3D%22en-US%22%3EMaybe%20this%20can%20help%20you.%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fwww.proworkflow.com%2Fblog%2F2009%2F10%2Fimport-csv-xml-files-into-excel%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.proworkflow.com%2Fblog%2F2009%2F10%2Fimport-csv-xml-files-into-excel%2F%3C%2FA%3E%3CBR%20%2F%3EThey%20have%20information%20on%20how%20to%20import%20XML%20and%20CSV%20files%20into%20excel.%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello everyone,

 

Currently I have a mapped table where all my XML forms are gathered, however I would like Excel to automatically import this data to me without having to click on the "import" click.

Is it then possible to update an XML mapping without necessarily importing?

 

Thank you in advance for your feedback,

cordially

 

Remy DARQUES

7 Replies
Import XML Files into Excel
https://www.howtoexcel.org/power-query/import-xml-files/

Just a info to help

@NikolinoDEthank you for your answer.

However it seems to me that this import method via Power Query only allows you to select a single XML file while my objective would be to bring all my new XML files back to my table from an actualization.

@Remi131765 

Other ways to import XML data

For more information about issues, see Common issues with importing XML data at the end of this article.

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

Hello @NikolinoDE,

Thanks for your answer but we don't know how it is possible to refresh an XML file folder

Remi

@Remi131765 

 

Refresh an external data connection in Excel

You can keep the data in your workbook up to date by "refreshing" the link to its source. Each time you refresh the connection, you see the most recent data, including anything that's new or has been deleted.

Security Note: Connections to external data may be currently disabled on your computer. To refresh the data when you open a workbook, you must enable the data connections by using the Trust Center bar, or you must place the workbook in a trusted location. For more information, see Add, remove, or modify a trusted location for your files, Add, remove, or view a trusted publisher, and View my options and settings in the Trust Center.

 

Click the heading for more information.

 

Thank you for your understanding and patience

 

 

Nikolino

I know I don't know anything (Socrates)

@NikolinoDE 

Hello,

First of all I'm sorry for the response time. I have consulted your links and everything seems ok to me, however I cannot update (see the photo).

 

I tell myself that maybe the problem comes from my files because they are in .xdp format and not .xml as Excel would like.

In this case, is it not possible to obtain data from a Folder that only takes into account .xdp files?

 

 

Remi131765_0-1617360365277.png

Thank you

Regards,

Rémi

 

Maybe this can help you.
https://www.proworkflow.com/blog/2009/10/import-csv-xml-files-into-excel/
They have information on how to import XML and CSV files into excel.