XML : 1B6 error while trying to create an XML map in Excel

When trying to create a XML map in excel I get the error 1B6: (Add-Ins Tab -> XML Tools -> Select Convert range to XML -> click OK button)

  fnMapRangeWithXml window which states     

   ERROR 1B6: Object doesn't support this property or method    

I have saved it before as an XML from excel, and had gotten any errors.

*Relevant for both 2007 and 2010 version of Excel.