Skip to Content
Former Member
Mar 18, 2009 at 08:51 AM

Using Workbook to meet requirements of special calculations in Report.


Hi All,

I have some questions on using Workbooks to format queries.

I have a BeX Query that has certain special layout requirements and special calculations for Result rows for which I need to use excel macros.

I have used a Workbook to achieve this.

Will the workbook reflect changes everytime I make some changes to the query structure?

Will the data be refreshed each time the workbook is opened?

How can the workbook be hosted on the Web in a 3.x environment ?

What are the possible ways client can access and launch the workbook?

Is there any better approach to do this other than using Workbooks?

Please let me know your thoughts on this.