updating pivot tables using dynamic data source
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
|