i am tring to create workbook in BI 7.0 version. I opened one report and saved as Workbook. Now when i tried to insert one more query in workbook, the previous query is not seen and the new query is executed.
1. Exectued the query and saved as workbook
2. In excel sheet created a new worksheet and in that i executed a new query
3. The previous query is gone and new query is being displayed.
Is creating workbook is different in 7.0 compared to 3.x.,,if yes can anyone plz provide me the documentation on that...
VBA is default installation with Excel.
I don't have much idea about Excel 2007.
Try to search in customize toolbar.