This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
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!!!!!!!
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
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.
Answer accepted by question author
You can share an Excel work book which contains Tables and Conditional, however you cannot share it if it contains tables or xml maps.
You may upload the sample file on Sky Drive to verify.
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?
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
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.
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?