Viewports

Anaplan XL Viewports help with the layout of variable length or width reports, allowing you to present information from one worksheet onto another. 

This can be helpful in many presentation situations. For example, you can have different worksheets for each business area, and put them together on a summary sheet that is organized. Viewports have several advantages over standard Excel camera objects:

Viewports can reference a large area on the source sheet. If the Viewport control itself is smaller than the range, it'll show vertical and horizontal scrollbars as required. This can be very useful for row dynamic reporting because the display area stays the same. Additional parts of the report below the Viewport can stay in place even if the number of rows in the Viewport changes. They also support freeze panes so that the row and column headers can always be visible as you scroll.

If the Viewport contains a Grid, the grid is still drillable and editable even through the Viewport. If there are active cell links that update other parts of the workbook, these are still interactive in the Viewport.

Viewports support specifying named ranges as the area (type in the name when picking a range). This works well when specifying Named Ranges on Grids or Tables with a dynamic number of rows/columns.