| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can i include new add data on my pivot table
Happy New Year and all the best.
I have a pivot table which looks up a worksheet data who's range change daily, i.e. new data are added every day. Is there a way to have the pivot table select all rows of data without having to change the data range manually everyday? many thanks. -- vicki |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how can i include new add data on my pivot table
Define a dynamic named range for the data and use that in the pivot table.
See http://www.contextures.com/xlNames01.html#Dynamic -- __________________________________ HTH Bob "vicki" wrote in message ... Happy New Year and all the best. I have a pivot table which looks up a worksheet data who's range change daily, i.e. new data are added every day. Is there a way to have the pivot table select all rows of data without having to change the data range manually everyday? many thanks. -- vicki |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how can i include new add data on my pivot table
Dear Phillips,
thanks for your quick reponse. But how I can connect this function to the pivot table? I have followed the step InsertNamedefine and input the said formula "=offset(data!$A$1,0,0counta(data!$1:$1))" on the data worksheet. What will be next step I need to do so that the pivot table can be updated automatically when new rows are added on the data worksheet. thanks again. -- vicki "Bob Phillips" wrote: Define a dynamic named range for the data and use that in the pivot table. See http://www.contextures.com/xlNames01.html#Dynamic -- __________________________________ HTH Bob "vicki" wrote in message ... Happy New Year and all the best. I have a pivot table which looks up a worksheet data who's range change daily, i.e. new data are added every day. Is there a way to have the pivot table select all rows of data without having to change the data range manually everyday? many thanks. -- vicki |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how can i include new add data on my pivot table
vicki,
You then use that defined name in the pivot table source data. -- __________________________________ HTH Bob "vicki" wrote in message ... Dear Phillips, thanks for your quick reponse. But how I can connect this function to the pivot table? I have followed the step InsertNamedefine and input the said formula "=offset(data!$A$1,0,0counta(data!$1:$1))" on the data worksheet. What will be next step I need to do so that the pivot table can be updated automatically when new rows are added on the data worksheet. thanks again. -- vicki "Bob Phillips" wrote: Define a dynamic named range for the data and use that in the pivot table. See http://www.contextures.com/xlNames01.html#Dynamic -- __________________________________ HTH Bob "vicki" wrote in message ... Happy New Year and all the best. I have a pivot table which looks up a worksheet data who's range change daily, i.e. new data are added every day. Is there a way to have the pivot table select all rows of data without having to change the data range manually everyday? many thanks. -- vicki |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how can i include new add data on my pivot table
Dear Bob,
it works now, many thanks for your help. -- vicki "Bob Phillips" wrote: vicki, You then use that defined name in the pivot table source data. -- __________________________________ HTH Bob "vicki" wrote in message ... Dear Phillips, thanks for your quick reponse. But how I can connect this function to the pivot table? I have followed the step InsertNamedefine and input the said formula "=offset(data!$A$1,0,0counta(data!$1:$1))" on the data worksheet. What will be next step I need to do so that the pivot table can be updated automatically when new rows are added on the data worksheet. thanks again. -- vicki "Bob Phillips" wrote: Define a dynamic named range for the data and use that in the pivot table. See http://www.contextures.com/xlNames01.html#Dynamic -- __________________________________ HTH Bob "vicki" wrote in message ... Happy New Year and all the best. I have a pivot table which looks up a worksheet data who's range change daily, i.e. new data are added every day. Is there a way to have the pivot table select all rows of data without having to change the data range manually everyday? many thanks. -- vicki |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table - include multiple worksheets with different ranges. | Excel Discussion (Misc queries) | |||
| In a pivot table, can the avg of a column include rows w/o data? | Excel Discussion (Misc queries) | |||
| in a pivot table, can the average include blank entries? | Excel Discussion (Misc queries) | |||
| Have a Pivot Table Include a "% of an item" | Excel Worksheet Functions | |||
| How do I manipulate pivot table report to include percentage of? | Excel Discussion (Misc queries) | |||
Linear Mode
