Workbook-level preferences and styling options are managed in the Workbook panel. To open it, choose Workbook from the ribbon in the Design group.
The Workbook panel contains three tabs: Preferences, Styling, and Components.
Objective
Workbook-level preferences and styling options are managed in the Workbook panel. To open it, choose Workbook from the ribbon in the Design group.
The Workbook panel contains three tabs: Preferences, Styling, and Components.
The Preferences tab is where you define the workbook's behavior. Key settings include:
Additional information can be found in the SAP Help Portal Permissions for the add-in.

The Styling tab lets you choose the preferred hierarchy styling, such as a level-based indentation style. These settings control the visual appearance of hierarchy members in your tables.

All add-in objects in your workbook, such as tables and data sources for formulas, can be managed from the Components tab in the Workbook Design group. You can group objects by sheet or by data source to get an overview of your workbook.

If named ranges associated with add-in objects are missing (for example, because a sheet was deleted while offline), the affected objects are listed in the Components tab. You can choose to restore or permanently delete each missing object at any time.
You should now be able to work with the Workbook design feature for the SAP Analytics Cloud, add-in for Microsoft Excel.