Hi,

I have a main, 'primary' spreadsheet which has a very extensive xsd schema and virtually everything is mapped. Some of the cells are just text but most contain formulae. This spreadsheet outputs xml files just fine.

However, some of the text fields in this primary spreadsheet need to be copied from another, much smaller spreadsheet (name of car make, name of model, size category etc). I have imported a very much cut-down version of the main schema into this ?secondary? spreadsheet and have mapped the relevant fields the same as the main one, so they have the same xpath in each. The secondary spreadsheet also exports xml OK (a much smaller one that the main one, of course).

The problem is when I try to import this small, ?cut-down? xml into the primary spreadsheet. The import works well for those fields contained in the small xml. However, for all of the rest of the main schema, the import overwrites formulae with blanks. Presumably it looks at the small xml and assumes blank values for all the fields not contained there. Is there some way to change this behaviour? Can I set it so that elements not contained in the small xml are simply not imported?

I could write a macro to copy data from one spreadsheet and put it into the other but this seems clunky, and prone to error if cells get moved around. I could duplicate a load of fields and have a separate import and export schema in the main spreadsheet, but that also seems a bit unnecessary. Plus, I?m sure this used to work OK in a previous version of the spreadsheet but I cannot for the life of me see what has changed.

Thanks for any help you can offer.

Aled