Thread: Event Question
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Event Question

You could have the macro specified in the setlinkondata do the updating or
you could simply have a formula on the second sheet refer to the cell on the
first sheet.

=Sheet1!A1

Regards,
Tom Ogilvy


"bwilcox" wrote in message
...
What Event or other such process will automatically update
a 2nd spreadsheet when the first sheet has been updated
via an external link set up through the SetLinkOnData
method?