Hi,

I have a Excel-Workbook containing Pivottables. They get their data
from a Access Database. I want to make a test whether the connection
to the Access Database is broken or not. Therefore I try to connect
and assume that I retreive an error in case of broken connection. My
problem is that there was no error thrown.

How can I control the error handling for RefreshAll? Or is there
another way to check the connection to the external data source?

Thank you,

Matti