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