| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Tables-Source Range continually increasing
Have the pivot table capture the entire columns of data you are looking for.
Then, use your Row and Column drop-down poxes in the pivot to de-select (blank). "CrimsonPlague29" wrote: HI, I have a set of data that is added to on regular basis, how can I automatically capture the new data in my pivot table by just refreshing table, without having to go and highlight the range each time ..... Thanks Crimson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Source Data in Pivot Tables | Excel Worksheet Functions | |||
| Force pivot tables to use same source data | Excel Discussion (Misc queries) | |||
| Increasing the Source Data range for an existing Pivot Table | Excel Worksheet Functions | |||
| updating pivot tables using dynamic data source | Excel Discussion (Misc queries) | |||
| Pivot Table data source "data source contains no visible tables" | Excel Worksheet Functions | |||
Threaded Mode
