| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Tables-Source Range continually increasing
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Pivot Tables-Source Range continually increasing
Have you tried using a named array to hold the data with plenty of spare
lines for new data. You should just be able to refresh the pivot table to show the new data? "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 |
|
#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 |
| Reply |
| 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 | |||
Linear Mode
