Excel: Having trouble sharing Excel tables with other workbooks?

Hi, Is there anyone how knows how to share an Excel table? I have a table which I would like to share with other workbooks but when I click the share workbook it says: '[I]This workbook can not be shared because it contains Excel tables or XML maps. To share this workbook, convert the table ranges and remove the XML maps.' [/I]I would like to use the Excel table as it automatically transfer formulas to the next row, if I convert the table range, I will have to copy and past my formulas into a new row every time I add one. I am not sure what XML maps are? I am currently using Excel 2007 on Win8. Please could someone help...... Matt

This question generated 58 answers. To proceed to the answers, click here.

This thread is current as of November 13, 2013.

For more resources for Microsoft Excel