How can I control RefreshAll

  • Thread starter Thread starter Matti
  • Start date Start date
M

Matti

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
 
I suppose it is a "feature, not a bug" so we don't get error messages
when a table is not open or inaccessible.

How about checking to see if the pivot table total changes ?
 
Back
Top