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?
Shared-QC-Log10022013.xlsx
JECoyneAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

KimputerCommented:
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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Aaron TomoskySD-WAN SimplifiedCommented:
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.
0
MurpheyApplication ConsultantCommented:
Try to save it as .xlsm or .xslb
0
redmondbCommented:
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 ).

Regards,
Brian.Shared-QC-Log10022013-V2.xlsx
0
JECoyneAuthor Commented:
This did w
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.