Pending Data Refresh warning error

  • Thread starter Thread starter Al
  • Start date Start date
A

Al

Hi All
When executing more than one Web query in a workbook I
get a pending Refresh warning message for the second and
following queries. The queries are executed in a macro
within a Do Loop using the refresh command.

! This action will cancel a pending Refresh Data Command.
Continue?

Is there a way to prevent the warning from occurring?

(I have a PC with Pentium IV at 2 GHz ; and a high speed
DSL link.)
Many Thanks
Al
 
Hi
add the line
application.displayalerts=false
before running the queries and enable the laerts
afterwards with
application.displayalerts=true
 
Back
Top