Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i change the data source
hi
i have pivottables that are referencing data from a worksheet in the same workbook. as i am adding data constantly to the worksheet how do i change the data range in the pivottable so it is reflected when i refresh thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i change the data source
Hi,
You need not change the range in the pivot table, cause pivot table automatically changes the range as per the data. Only Make sure the data entered is with in the selected table array for the pivot table. Once finished doing data entry you can go to Pivot table toolbar/refresh. The pivot table will automatically reflected the new data entered. -- Thanks Suleman Peerzade "derwood" wrote: hi i have pivottables that are referencing data from a worksheet in the same workbook. as i am adding data constantly to the worksheet how do i change the data range in the pivottable so it is reflected when i refresh thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i change the data source
If you have added data to the bottom of the range used for the pivot table,
then note the address of last cell of the range, often the column will be the same, just the row number will be increased. Then click on the pivot table anywhere, click on Data, Pivot table & pivot chart report. In the box which appears click on back Amend the range (often just the row number will have to be edited) Then click on finish. I hope that is what you wanted, Barbara "derwood" wrote in message ... hi i have pivottables that are referencing data from a worksheet in the same workbook. as i am adding data constantly to the worksheet how do i change the data range in the pivottable so it is reflected when i refresh thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change Source Data in a Graph | Excel Discussion (Misc queries) | |||
Is there a way to keep the formulas and change their source data? | Excel Discussion (Misc queries) | |||
change odbc data source | Excel Worksheet Functions | |||
MS Query Data Source Change | Excel Discussion (Misc queries) | |||
change data source for many queries at once? | Excel Worksheet Functions |