View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ToddEZ ToddEZ is offline
external usenet poster
 
Posts: 60
Default 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?