When extracting data from an external source, the following message
appears when the spreadsheet opens:

"Microsoft Excel cannot refresh a Pivot Table until refresh of the
external data range on which the Pivot Table is based is complete."

Hitting the "OK" gets past the warning and the spreadsheet functions
normally. Is there any way to suppress the warning so the user does not
need to hit the "OK"?

Thanks for your help.