Navigation
This topic describes the user interface elements of Excel Integration.
Each time you launch the add-in, it is displayed on the Home tab at the right of the ribbon. You can customize the ribbon and change the position of the add-in.
This table shows the buttons and icons that you use within the add-in:
Button | Description |
---|---|
Show Infor d/EPM task pane | |
Add an ad-hoc report | |
Add a Self-Service report | |
Add horizontal elements | |
Add vertical elements | |
Add filter elements | |
Add a value | |
Recalculate a workbook | |
Recalculate a sheet | |
Recalculate a selected area | |
Edit element formula | |
Enable writeback mode | |
Convert an ad-hoc slice report to a cell-based report. The active cell must be within the report area. | |
Access online help | |
Open customer support website | |
Access information about Infor d/EPM | |
Access the switch option. | |
Switch between vertical and horizontal element formula generation. | |
Select between read-only and read and write formula generation | |
Reference a cell | |
Select all default hierarchies of unused dimensions in the Filters section of
an ad-hoc report. Unused dimensions are those from which you have not manually selected any hierarchies for filters, columns, and rows. |
|
Edit filters, columns, and rows in an ad-hoc report | |
Remove a selected hierarchy from an ad-hoc report | |
Select a display format for a list of elements or for a resulting formula. | |
Select which elements from a list of elements are visible. | |
Enable zero suppression on ad-hoc report rows, columns, or on both. Any row or column that contains only zero values is hidden. If the row or column contains at least one non-zero value, the zero values in that row or column are still displayed. | |
Perform a search. | |
Open a list with options. |