I have a workbook with a financial model where I use an XML that I export / import to mapped cells in the workbook. When I use XLS Padlock to compile the workbook to an .exe file, the schema is no longer mapped to the cells in the workbook. (But the schema is available in the workbook, but not mapped).

I get the following message error message:

“Run-time-error 1004.  No data was imported because no elements have been mapped.  Use Range.XPath.SetValue to map XML elements on the worksheet”.

 

Solution:

Turn the following option on: “Use Excel automation for formula protection” available in Formulas and Passwords.