ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Win98 SE, Office 2000: ODBC from Excel behaves strangely on one computer (https://www.excelbanter.com/excel-discussion-misc-queries/17491-win98-se-office-2000-odbc-excel-behaves-strangely-one-computer.html)

Arvi Laanemets

Win98 SE, Office 2000: ODBC from Excel behaves strangely on one computer
 
Hi

When I create an ODBC query from another Excel workbook, using query wizard,
then usually after I select the workbook as data source, in wizard's next
window all available tables (defined non-dynamic named ranges in this
workbook) are displayed, ans I'm asked to select columns. The source
workbook remains closed.

Now in one single computer, after I select the workbook as data source, this
workbook is opened and recalculated automatically, and only after that the
wizard continues with next window. And when I open some workbook, containing
such ODBC query, or when I try to refresh such query after I opened the
workbook without refreshing external data at start, the source workbook is
opened too again. I uninstalled Office from this computer, cleaned registry
with microsoft's Eraser2K, installed Office anew, and updated it (SR-1a +
SP3), but all this didn't help.

Has anyone some experience with such situation, and can give some advice,
how to correct this. Or is Window's clean install the only cure?

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets




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

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