Query another Excel File (Excel 97 SR2)

Topic

New Reply

Difficulty using MS Query wizard to extract data from an Excel file on a shared lan. The file contains 5 worksheet tabs. The data list is on one tab. There are no blank columns or rows in the list and the column labels are unique from the data. It is in a AutoFilter mode, but if I take it out of autofilter mode it doesn’t change the results. There is a Named Range for the data list and it is the only named range in the file. The error message returned by query is there are no visible tables in the source data. I’m at a loss as to what to check next. Any ideas. Thanks for your input in advance

Reply | Quote