I am struggling with the same problem at the moment, Excel doesn't seem
to like A1 style references in XML, you can use R1C1 + R2C1 though i.e.
absolute addressing rather than relative but it only seems to like the
R1C1 style, hope this helps. Please post back if you resolve the A1
style referencing.