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.