Skip to main content

How to enable dynamic grid

You are here:

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