| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking Pivot Table data
How can I link the data in a pivot table to the data?
i have data in one sheet and i made a pivot table on another sheet. When i updat the data (i am not adding rows or columns - just changeing the contant of the cells) the new data does not show up in the pivot table. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Linking Pivot Table data
Right Click on PT and choose "Refresh".
It is not a link such as a formula will give you and needs to be refreshed anytime you update the source data Regards Ken........................... "culbie" wrote in message ... How can I link the data in a pivot table to the data? i have data in one sheet and i made a pivot table on another sheet. When i updat the data (i am not adding rows or columns - just changeing the contant of the cells) the new data does not show up in the pivot table. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Linking Pivot Table data
Thank you
I posted the second time because of my typo in the Subject line. "Ken Wright" wrote: Right Click on PT and choose "Refresh". It is not a link such as a formula will give you and needs to be refreshed anytime you update the source data Regards Ken........................... "culbie" wrote in message ... How can I link the data in a pivot table to the data? i have data in one sheet and i made a pivot table on another sheet. When i updat the data (i am not adding rows or columns - just changeing the contant of the cells) the new data does not show up in the pivot table. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Linking Pivot Table data
No problem - most people on here will understand what you mean :-)
Regards Ken...................... "culbie" wrote in message ... Thank you I posted the second time because of my typo in the Subject line. "Ken Wright" wrote: Right Click on PT and choose "Refresh". It is not a link such as a formula will give you and needs to be refreshed anytime you update the source data Regards Ken........................... "culbie" wrote in message ... How can I link the data in a pivot table to the data? i have data in one sheet and i made a pivot table on another sheet. When i updat the data (i am not adding rows or columns - just changeing the contant of the cells) the new data does not show up in the pivot table. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| linking cell to Pivot Table data | Excel Worksheet Functions | |||
| linking worksheets into a pivot table | Excel Worksheet Functions | |||
| linking pivot table data to a cell in other sheet | Excel Worksheet Functions | |||
| Pivot Table Linking | Excel Discussion (Misc queries) | |||
| Linking Combo box to pivot table? | Excel Discussion (Misc queries) | |||
Linear Mode
