Formatting the workbook on opening(not just on refreshing)

Hi All,

I am working on a Business Planning Application on BI 7.0, Integrated Planning.

<b>Is there a way to format the query output in a workbook when the workbook is opened?</b>

I am aware of the SAPBEXRefresh which one can assign as macro and do formatting.

But this doesn't work if you have set the workbook properties as "Refresh on Open" and query is refreshed when the workbook opens.

Thanks

Nitin.