I am using Excel Pivot Tables Recipe Book by D. Dalgleish and am in chapter
7, “Updating a Pivot Table”. The data source for the pivots always begins in
cell A10. Column BL is always the last column, but the number of rows will
vary. The data are updated monthly. I followed the steps for naming the
data range using A10 instead of A1 as the starting place, but when I try to
use the named range for the data source for my pivot table, I get an error
message stating “Reference is not valid”. I am using Excel 2003. Any
suggestions?--
dab4211