G
Guy
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.
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.