View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bill E. Hollywood, FL Bill E. Hollywood, FL is offline
external usenet poster
 
Posts: 2
Default Pivot tables not refreshing after data source update

The resolution to this was to add

..BackgroundQuery = False

to the OLEDBConnection just before the call to Refresh. Thank you to
Bill Manville and Jan Karel Pieterse in the Compuserve Office forum
for the suggestion.

Bill