1. Launch the BEx Analyzer.
2. Using the Excel toolbar, open your previously saved template.
3. Follow the Excel menu path and choose Tools > Options > View. Remove the checkbox for Gridlines.
4. Using the BW BEx toolbar, select the Save icon > Save Existing workbook.
5. Open a BW Query into the BEx Analyzer and your template will appear without gridlines.
CREATING HIGH IMPACT BW WORKBOOKS
Scenario 1: I need to create a customized template with my company's logo
Scenario 2: I need to create a template without gridlines
Scenario 3: I need my users to have the latest data available
Scenario 4: I need to publish reports where users can't modify the layout of the report
Scenario 5: I have a requirement to put all my reports into a single package
Scenario 6: I want to lock the data values found in my BW reports
Review: Conclusion and more resources