How to fix [Microsoft]ODBC Driver Manager] Data source name not found and no default driver specified pivot table Excel 365 connecting to csv file

Hi @David Marjolin

Thanks for your sharing.

By the way, since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others.", and according to the scenario introduced here: Answering your own questions on Microsoft Q&A, I would make a brief summary of this thread:

Issue Symptom:

In Excel for Microsoft 365 Apps, pivot table (relies on data from .CSV files) can not refresh data.

It uses the connection string which has been saved in an .ODC file.

Error message 1: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.

Error massage 2: Problems obtaining data

Current Status:

Solved via David Marjolin self.

Create a Data Source in the 64-bit of ODBC Administrator and prepend the Data Source Name in the connection string as follows: DSN=<the created DNS>

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

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.