How to make ImportXML run faster
 

Dear everyone,

My company's sales force is using a workbook which they periodically
synch with backend system

How it works is the workbook exports the workbook into XML, call a
method in backend web service and passes the XML string over. A fresh
new XML string is returned after processing. Workbook loads in the XML
using ThisWorkbook.XmlMaps("Changed").ImportXml method.

If the XML is big- 16000 records in sheet1 and 5000 records in sheet2,
the ImportXml takes 40 minutes to complete the import, causing a long
wait for time to user.

Is there anyway to make ImportXml run faster ?

regards
Houston Shum