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/