I am trying to update an excel report that someone else created. Anytime I select Data > Refresh All I get the following error: [ODBC Driver Manager] The specified DSN contains an mismatch between the driver and application

Question

Answer 1

Hi,

What version of Excel did you use?

Where did you get the file?

Did you try to create a new connection and check if you can connect to the source and update data?

Here are a few steps you can take to resolve this issue:

1. Ensure that the architecture (32-bit or 64-bit) of the ODBC driver matches the architecture of the Excel application you are using. If Excel is 64-bit, you need a 64-bit ODBC driver, and similarly for 32-bit Excel.
2. Make sure you download the correct version from the official source. Sometimes, updating or reinstalling the ODBC driver can resolve compatibility issues.
3. Running Excel with administrative privileges can resolve certain permission-related issues.

Please try these methods and check if these will help you. Please let us know if you would like further assistance.

---

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.