Attempting to share and Excel file among 5 users

I keep getting an error message when I attempt to share a file among a small group of users (3-5 at the most).  The error suggests that there are Excel tables or XML maps.  I did not originate the Workbook, but did modify it to include drop-down lists to keep the data a little more consistent.

I tried to copy the data (only - which included the named ranges I specified) to a new sheet to ensure the table did not come along, but still got the same error message.

Can somebody advise me? Is this a bug in Excel or am I doing something incorrectly?
Who is Participating?
KimputerConnect With a Mentor Commented:
I can share it using Excel 2003. So maybe you can too (first save as .xls, it will tell you about losing some info, just ignore it), then share it. If it works, save that .xls to .xlsx again, and share it).
Anyway, usually Excel sharing leads to data inconsistencies, data corruption and big files. If no special Excel features are needed, only simple spreadsheet functions, I would recommend to share a google docs spreadsheet instead.
Aaron TomoskyTechnology ConsultantCommented:
It's a spreadsheet not a database. Install the free ms SQL express, import your excel sheet. You can still reference it from excel or access or make a web page, but this will fix your sharing problems.
MurpheyApplication ConsultantCommented:
Try to save it as .xlsm or .xslb
Hi, JECoyne.

There is a table ("List1") on the "Employees" sheet. When I converted that back to a range, the "Sharing" option worked - please see attached.

BTW, the last row on "Employees" was 65,518, so I deleted the empty cells. "QCLog" could also do with significant tidying up.

Edit: Finally, if you need another warning about the dangers of sharing spreadsheets, please see this post from matthewspatrick (a Microsoft Excel MVP and one of the site's top 10 Experts ).

JECoyneAuthor Commented:
This did w
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.