View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ken Wright Ken Wright is offline
external usenet poster
 
Posts: 634
Default 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.