Excelxp writes XML and that may be the main issue.
To see what the XML might be, make a base spreadsheet in excel that does what you want. The SAVE AS XML.
Look in the resulting XML file with a text editor like Notepad.
I am not sure if XML supports any look up and that may be the reason that going through the XML translation it gets lost.