| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I extend the range of the data used in a PivotTable?
Hi
On the Pivot table, click on the pivot table wizard, select back, and increase the range of the rows. It should just bne the number you need to change. I would suggest, putting in a row range much bigger than needed, so it will take into account all future extracts Thanks Matt 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? -- Matt Lynn Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200808/1 |
| 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
