View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tomas Tomas is offline
external usenet poster
 
Posts: 13
Default Pivot table: hyperlink back to source data

I am using pivot table to generate sales forecast from my source data. Is
there a way I can directly jump back to the source data to edit them? If I
double click the value in pivot table I only get a detail on a separate new
sheet with respective records. Can I include any form of hyperlink or macro
action into the pivot table to manage the link? Thanks.