| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table Range
This is the same question as someone posted on 08/0/07 however I dont
understand the answer. I have a pivot table reading data from a worksheet which continually grows. I would like to refresh the pivot without having to go into the data and change the range each time. Does anyone know a way for this to happen? any help would be appreciated. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Pivot Table Range
Its all good, it was quite simple i just read it wrong, sorry guys
"Scott R" wrote: This is the same question as someone posted on 08/0/07 however I dont understand the answer. I have a pivot table reading data from a worksheet which continually grows. I would like to refresh the pivot without having to go into the data and change the range each time. Does anyone know a way for this to happen? any help would be appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic range in Pivot table | Excel Discussion (Misc queries) | |||
| Help Pivot Table Date Range | Excel Discussion (Misc queries) | |||
| Dynamic Range in a Pivot Table | Excel Discussion (Misc queries) | |||
| Multiple Range Pivot Table | Excel Worksheet Functions | |||
| Setting Range in Pivot Table | Charts and Charting in Excel | |||
Linear Mode
