You can either name the range that you want to query (Select the range, then
go to the name box, the white box to the left of the formula bar, type a
name and press Enter), or, check the 'System Tables' box that appears in the
'Table Options' dialog.

--
Regards,

Juan Pablo González
Excel MVP

"kit" wrote in message
...
trying to run MS query from a excel spreadsheet. Error of 'no visible
tables'. Checked no hidden rows or columns. please help, driving me
crazy