Share via

Error: "This workbook cannot be shared because it contains excel tables or XML maps

Anonymous
2012-02-28T18:00:20+00:00

I'm trying to share a work book that I added Drop Downs and Conditional Formatting, but I'm getting the following error: "This workbook cannot be shared because it contains excel tables or XML maps".

If I have drop downs and Conditional Formatting, am I not able to share this worksheet?

Hopefully that is not the case, otherwise, what a waste of time!!!!!!!

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments
Answer accepted by question author
  1. Anonymous
    2012-02-29T10:59:50+00:00

    You can share an Excel work book which contains Tables and Conditional, however you cannot share it if it contains tables or xml maps.

    http://office.microsoft.com/en-us/excel-help/use-a-shared-workbook-to-collaborate-HP010342985.aspx?CTT=1

    You may upload the sample file on Sky Drive to verify.

    50+ people found this answer helpful.
    0 comments No comments

7 additional answers

Sort by: Most helpful
  1. Anonymous
    2015-08-07T15:57:39+00:00

    Hello Daniel,

    Sorry, I know you posted this a long time ago. I am having a similar issue. I have a workbook I would like to share. However, I format the spreadsheet as a table in order to keep every other row a different color. When I filter a column, every other row stays their perspective colors. But, when I convert the table to a range so I can share the document, every other row does not stay its perspective color once a filter is applied to a column. I have tried writing a formula via conditional formatting but it gets jumbled once the cells are filtered also.

    In summary:

    I want a shared workbook that has every other row (light blue).

    When a filter is applied I want it to stay every other row (light blue).

    Is there a solution to this?

    100+ people found this answer helpful.
    0 comments No comments
  2. Anonymous
    2013-10-11T03:22:31+00:00

    Hi Daniel and Experts!

    My Excel file does not contain an XML map but I am not able to share the workbook.

    I've checked Developer -> XML -> Source and it's empty.

    Can you please advice how to do?

    Thanks much!

    Jackie

    10+ people found this answer helpful.
    0 comments No comments
  3. Anonymous
    2013-10-13T10:26:28+00:00

    Hello Jackie,

    From your description, I understand that you're unable to share an Excel workbook.

    Is there any tables in the workbook which you're trying to share? If yes, did you try converting the tables to ranges and check?

    To convert a table to a range, select the table, and then on the Design tab, in the Tools group, click Convert to Range.

    Feel free to reply if you need more assistance and I’ll be happy to help you.

    Thank You.

    7 people found this answer helpful.
    0 comments No comments
  4. Anonymous
    2014-03-15T21:54:34+00:00

    I inherited a workbook that I am trying to share (excel 2007) and I get the error as referenced above, can't share a workbook with tables or XML. I have neither.  My XML source is blank and I created a table and deleted it just to be sure there were no tables.

    What do I try next?

    1 person found this answer helpful.
    0 comments No comments