Parameter query

G

Glenn Daelman

Hi
I make parameter query in excel 2003.
The query works fine and automaticly update.
I used a cell as parameter.
He qurey is on sheet RuweQrYGegevens
And the parameter cell on Sheet basisinfo.
So far no problem.

On sheet basisinfo cell d5=RuweQrYGegevens!c7
That works fine. But when i put no vallue in the parameter cell and press
enter
The query change the formula in d5=RuweQrYGegevens!verw and i must
d5=RuweQrYGegevens!c7.
what is wrong.

Greetings
Glenn
 
Top