Report options / Additional options / Documentation / XL Report Builder Official Home Page

Template options / Additional options / Report options

Report options are specified in the cell A1 of any sheet (or several sheets) of the workbook-template. Working with every sheet of the workbook-template, XL Report Builder necessarily uses the value of this cell. If XL Report Builder meets there some known to it option, it performs additional actions with the result workbook after the report execution. In the table below there is list of the available options:

OnlyValues	Replaces every formula in the report workbook with its calculated value.
ShowPivotBar	Turns on the Pivot table bar. This bar is hidden by default even if the report contains a pivot table. This panel allows the user to edit the Pivot table. See Excel Help for additional information.
AutoSafe	Protects a report workbook with a random password. This corresponds to the Tools/Protection/Protect Workbook menu command with the Structure check box on. The use of AutoSafe on report levels completely protects a report workbook because the Tools/Protection/Protect sheet menu command is applied to every worksheet in the workbook.

Note

All enumerated report options can be placed on any sheet (or sheets). If the options are placed on several sheets, they complement one another.

[ Back to Table of Contents ]