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
|