ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Data Source Name Not Found (https://www.excelbanter.com/excel-worksheet-functions/31182-data-source-name-not-found.html)

Justin Tyme

Data Source Name Not Found
 
I was sent a spreadsheet SHEET1 constructed under data source name "A". When
I create data source "A" on my machine and click the refresh button, it gives
a "[Microsoft] [ODBC Driver Manager] data source name not found" message.
When I click OK, it gives that message again. When I open another
spreadsheet SHEET2 from the same person, under the same data source name "A",
it refreshes OK under the same circumstances. Also, if I don't create data
source "A" on my machine, and click REFRESH DATA in SHEET1, then I get the
message twice. If I do the same for SHEET2, then I get the message once, but
then I get a "Select Data Source" window, where I can select a data source.
It seems that SHEET1 is behaving differently, and I'm not sure why - you
cannot refresh the data source on any machine other than the one that created
it (at least I assume that is the case, but I'm having them check it out).


All times are GMT +1. The time now is 08:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com