Connecting Data in Excel 2013

I've exported a query using DoCmd.OutputTo command from MS Access 2013 as a *.xlsx file and created an Excel 2013 workbook to connect to the data from the exported spreadsheet but getting an error message saying "We found a problem with some content....".

It works the first time, but when I export the query again and open the template to update I get the error message.

Does anyone know how I can resolve this?
LillyCAsked:
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.

als315Commented:
Can you open export from Excel directly?
0
Rob HensonFinance AnalystCommented:
Can you not link the template directly to the Access Database rather than exporting to a separate file?
0
LillyCAuthor Commented:
als315 - Yes I can open the export from Excel.
Rob - the database is password protected, so didn't want to link directly
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Rob HensonFinance AnalystCommented:
If you link to the query you will still only get the query results and nothing else. Not sure whether you would need the password to update though.
0
LillyCAuthor Commented:
I've just tried that Rob and the password is needed, I know my client will not want to share their password with the person who requires the Excel data.
0
als315Commented:
It is strange that you can open this file without problems, but can't link it.
You can export results of query to unprotected Access Database
0
Rob HensonFinance AnalystCommented:
Are you saving the exported file or linking to it straight after it is created from Access?

If linking to it straight after creation I suspect it is something different in the filename or location.
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
LillyCAuthor Commented:
Thanks als315 and Rob, but I've found the problem and solution in the below link:

https://superuser.com/questions/1121810/excel-when-connected-to-external-data-we-found-a-problеm-with-some-content-in
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.

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.