Grids 0:50 video

How to enable dynamic grid

Enable the dynamic grid option in a SpreadsheetWeb application to make the grid layout respond to the available data and runtime display.

0:50 video One focused outcome Updated April 1, 2026

To Enable Dynamic Grid,

In your Excel file click on the top-left cell of the dynamic pivot table
Give that cell a single named range
Save Excel and create a new application
Go to User Interface Design
Drag and drop the Output Grid control
Select "Enable Dynamic Range" option and select the single named range that you created