If you try to export large list in Excel under the following conditions, view problem occurs in the exported Excel file.
1. You have a list which has more than 10000 items.
2. Creating a filtered view in this list that has a column index.
In this scenario, the list is shown in the expected filtered view, but if you export this list view into Excel, the filtering won’t be exported as expected and items IDs are listed in wrong order in the exported .iqy file.
Please improve this exporting behavior to correctly display items in the expected view.