How can I control RefreshAll
 

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

How can I control RefreshAll
 

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 ?


---
Message posted from http://www.ExcelForum.com/