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,EmployeeNamesMgr,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 "auto update" etc
Does Excel have a problem using Data Validation - Lists and Data Query
refresh?
Thanks
Bookmarks