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?
LillyCDatabase DeveloperAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
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?
Rob HensonFinance AnalystCommented:
Can you not link the template directly to the Access Database rather than exporting to a separate file?
LillyCDatabase DeveloperAuthor Commented:
als315 - Yes I can open the export from Excel.
Rob - the database is password protected, so didn't want to link directly
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

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.
LillyCDatabase DeveloperAuthor 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.
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
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.

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
LillyCDatabase DeveloperAuthor 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
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.