I've come across a problem that no amount of googling is helping me with.
While refreshing workbooks with pivots (that are externally linked to another excel file containing the data) using VBA ( .RefreshAll), a dialog box titled "Data Link Properties" pops up.
I've tried to suppress the dialog...