Scenario 2: I need to create a template without gridlines

Scenario 2: I need to create a template without gridlines

Solution:

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

 Home: Introduction
 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

This was first published in August 2005