Excel2003 will not allow me to refer to another worksheet if I want to create
a Data Validation Settings: List.

I would like some help on how to return a range of data from a PivotTable. I
am familiar with the getpivotdata() function; is there a neat way of
collecting a range.

My thoughts are to create an array in a cell that might be used in the Data
Validation Settings: Source.