Refresh Query if office 2007
I recently upgraded to office 2007.
I have a workbook that was setup to run a query whenever one of the
paramaters changes. Since I upgraded to 2007, the query does not refresh
until I click "refresh all". My parameters have not changes, and the check
box that says "refresh when cell A1 is changed" is still clicked. ...Am I
missing something?
What is the code to refresh all if cell A1 is changed?
|