i have linked three excel workbook. First is source workbook. second one is on which i have done calculation and third workbook shows result. Now my query is
1: i want automatic update reflects on third excel workbook( showing result) when i do any change in source wb without opening second workbook.

2: how to share final workbook(showing result) with others without sharing first and second workbook.