| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I extend the range of the data used in a PivotTable?
You can base the pivot table on a dynamic range, as described he
http://www.contextures.com/xlPivot01.html Jaybatz wrote: I make weekly budget reports, and I use a PivotTable to get a basic overview. Now the problem is that as I extract data weekly, it changes and rows are added to the original data each time. The PivotTable does not recognize this and only checks the original field range. How do I change the range, without having to create a new PivotTable every week? -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cannot extend the range of data I'm trying to prevent duplicates i | Excel Worksheet Functions | |||
| Unchecking "Extend data range formats" is not workingfor row shading | Excel Discussion (Misc queries) | |||
| Extend a data range | New Users to Excel | |||
| Extend data range format and formulas | Excel Worksheet Functions | |||
| extend data range formats and formulas | Setting up and Configuration of Excel | |||
Threaded Mode
