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: '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 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.