Print Area in Excel BOM
The stadard behavior in Excel BOM is to assign the print area to include all the columns with data and no limitation on the number of rows, as Excel will calculate the rows filled with data automatically.
If you check in the Excel BOM Designer the option
the print area is not assigned and the original print area as defined in the associated template is perserved.