I have a user who has a worksheet set up and wants to create a query.
Through the query wizard, when he goes to select the columns he wants to
include, he has a Sheet1$ option and a Sheet1$_FilterDatabase option. Now he
would like to use the FilterDatabase option because the columns have nice
names. However, when he goes to the next step where you select a column and
select an operator such as equals, the data in the right column doesn't
automatically populate. However, if I use the Sheet1$ option, all the
columns have generic names like F2-F16, but it seems to work correctly when
we go through the wizard. It doesn't work on his machine or mine, but it
worked for someone else. Is there something I can check to make the
FilterDatabase option work correctly? We are using Excel 2002 SP3 on Windows
XP. Thanks.