Trying to read the properties of a pivot table. As soon as I try to
read activecell.pivotfield.childfield.name for a pivot table whose
selected pivotfield does not have a childfield I get an error: "Unable
to get the childfield property of the pivotfield". That is what the
documentation says it will do.

However, once this happens (under On Error Resume next) the pivottable
does not recover even though the code continues to run. In subsequent
lines, any reference to properties of the pivot table returns "Unable
to get the xxx property of the pivotfield class".

I'm in Office 2000 SP3, Windows XP.