Export to Excel functionality exports all rows and columns from a view whether the view is running in the collapsed mode (also known as page mode) or running in expanded mode. Collapsed mode means that only a select number of rows and columns will display per page, as determined by a View Page Size setting that is controlled by either you or your administrator. In the following example, settings are such that 20 rows display per page. Expanded mode means that all rows and columns are displayed. Only 20 of the 15,076 rows of the following view are displayed currently, but all 15,076 rows would be exported.
Keep in mind that if your view has an exceptionally large number of rows and columns, it may take longer to export.