I don't see an "Add Workbooks" option on MS Query (where do you find it on
your version?)
but....a sheet name with a dollar sign (eg Sheet3$) indicates that the sheet
should be used as a data table (versus a named range)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Janie" wrote:

Sometimes when using MS Query, I can select multiple datafiles to construct
my quuery with, but sometimes that is greyed out. Why?? Oh, I also notice
that when the "Add Workbooks" is greyed out, the file that I am conected to
places a dollar sign chaacter after the shet name, though in the file, the
sheet name does not have the dollar sign character. What is this tryign to
tell me?

Thanks

Janie