Issue in Precalculation Workbook

Hi All,

We are broadcasting workbooks to Sales Specialists based on the area they belong to.Broadcasting works with out any issues except if the Sales Rep has no sales in that case a default workbook is going out to him.

While executing the workbook, we have to set ourself as a sales member (we have an authorization exit here) and in case this , if a Specialist has 0 data , default values are going out to him.

Our Workbooks have multiple sheets with the Pivot Tables and Lookup info.Any light thrown as to how to broadcast blank workbook in case of no data in the main report is highly appreciated,

Regards,

Sasidhar