software

I have a data query that does not refresh automatically when a value if a
parameter cell changes (this cell is A12). There is a formula of the
following in this Paramter cell A12

=IF(B15=0,0,INDEX(StaffNoMgr,MATCH(B15,EmployeeNam esMgr,0)))

The value returned using the above formula changes when B15 changes - I do
this through Data Validation - List

The value returned in A12 is valid and it changes when B15 changes
correctly. My problem is that my Data Query does not refresh. I can go into
the sheet where the Data Query is a run it, and it works fine, but it will
not automatically refresh when A12 changes

I seem to have all settings correct, in that I have the parameter values set
to quot;auto updatequot; etc

Does Excel have a problem using Data Validation - Lists and Data Query
refresh?

Thanks