office add-ins error while importing tables to ms excel in ax 2012


" cannot load[table name ]. table must have a valid replacement key or a primary index other than RecID for use in the office Add-ins".how to solve this error.


You are required to create a primary index other than a RECID in your table, also need to set the index’s “alternatekey property” to YES and need to set this index in table’s Replacement key property.

Still getting the same error after setting the Replacement Key Property[*-)]