Excel startup

[Luka]

Hi,

this is not really a problem but anyway. I' m getting data into excel (pivot table) from access db. Pivot table is set to refresh data from access every time at startup, but at the startup I get this form in which I must confirm data refresh. Is it possible that this form is somehow shut down or bypass (and I want to keep my auto refresh settings).

Sorry for mistakes in language.

 

[shades]

Not sure, but include:

' at the beginning of your code
    Application.DisplayAlerts = False

' at the end of your code
    Application.DisplayAlerts = True

________
190

 

[Luka]

Thanks that solves the problem.