Hi,

The connection must be made using MS Query or New Web Query.

suppose you used MS Query, then return to it and display a criteria area,
then enter the field(s) you want parameters for and then under them on the
criteria row enter something like [What City?] in square brackets. Return
to Excel and when you refresh you will be prompted.

If you want to use wildcards, something like this

Like [What city] & '%'

is entered on the criteria row in MS Query.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"vkeller" wrote:

My fill and text colors no longer display on my monitor. They are on the
printed document but are not visible on the computer screen. The text only
displays as black and cells only display as white. I do not have this
problem with any other applications, only with Excel. Any ideas as to what
may have happened?
--
vkeller