Issue with large excel output in BI Publisher

If you are facing large memory issue in excel output of BI Publisher. Use Excel template to overcome that issue.

You can also use the excel features to render charts and pivot tables.