| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table data not matching source | Excel Discussion (Misc queries) | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| Pivot Table data source "data source contains no visible tables" | Excel Worksheet Functions | |||
| updating pivot tables | Excel Discussion (Misc queries) | |||
| Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel | |||
Threaded Mode
