View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Carl Carl is offline
external usenet poster
 
Posts: 361
Default Code To Refresh Query Table

I am trying to refresh data in a query table but the following code does not
work: "Selection.QueryTable.Refresh BackgroundQuery:=False". If I just
right-click on the cell containing the querry and select "Refresh data" from
the menu it works fine but this must be automated. Please advise if anyone
knows the correct code. Thanks in advance.