Solution:
1. Launch the BEx Analyzer.
2. Using the Excel toolbar, open a previously saved workbook.
3. In order to have the most relevant data appear you want to make your workbook "auto-refresh".
4. In the results section of your report, right-click on any field and choose Properties.
5. Navigate to the Interaction tab.
6. Check 'Refresh query when opening workbook'. Click ok.
7. Using the BW BEx toolbar, select the Save icon > Save Existing workbook.
8. The next user to open this report will automatically receive the latest data from the BW database.
CREATING HIGH IMPACT BW WORKBOOKS
Home: Introduction
This was first published in August 2005