Home

Refreshing XML map overwrites existing data

%3CLINGO-SUB%20id%3D%22lingo-sub-239285%22%20slang%3D%22en-US%22%3ERefreshing%20XML%20map%20overwrites%20existing%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-239285%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20created%20an%20XML%20map%20to%20pull%20RSS%20feeds%20onto%20my%20spreadsheet.%20However%2C%20when%20I%20refresh%20the%20table%2C%20it%20overwrites%20the%20existing%20data.%20I%20don't%20want%20the%20older%20feeds%20to%20be%20overwritten.%26nbsp%3BI%20would%20like%20to%20keep%20a%20track%20of%20all%20the%20feeds%20coming%20in%20over%20time.%20How%20do%20I%20avoid%20overwriting.%20I'm%20using%20Excel%202016.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-239285%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%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-330672%22%20slang%3D%22en-US%22%3ERe%3A%20Refreshing%20XML%20map%20overwrites%20existing%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-330672%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20have%20a%20similar%20issue.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20click%20on%20%3CEM%3EXML%20Map%20Properties%3C%2FEM%3E%20in%20the%20%3CEM%3EDeveloper%3C%2FEM%3E%20panel%2C%20I%20cannot%20deactivate%20%3CEM%3EOverwrite%20existing%20data%20with%20new%20data%3C%2FEM%3E%20as%20the%20function%20is%20not%20active.%20Would%20love%20to%20know%20how%20to%20access%20that%20function.%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%20style%3D%22width%3A%20331px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F71961iCBB9C56FB92560F8%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Cap_01.JPG%22%20title%3D%22Cap_01.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3ELet's%20hope%20somebody%20has%20ideas.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Mariam Ahmed
Visitor

Hi,

 

I have created an XML map to pull RSS feeds onto my spreadsheet. However, when I refresh the table, it overwrites the existing data. I don't want the older feeds to be overwritten. I would like to keep a track of all the feeds coming in over time. How do I avoid overwriting. I'm using Excel 2016. 

1 Reply

Hi,

I have a similar issue.

 

When I click on XML Map Properties in the Developer panel, I cannot deactivate Overwrite existing data with new data as the function is not active. Would love to know how to access that function.

 

Cap_01.JPG

Let's hope somebody has ideas.

 

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
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies