locked
Excel removes filters when export from SharePoint online library. RRS feed

  • Question

  • One of our client is exporting a large Excel file from SharePoint online to Excel app which is installed in the local pc. Everything is okay except the filters are completely removed. She can re-apply necessary filters but it takes time. Is there any way to preserve the files while exporting?
    Tuesday, January 7, 2020 5:50 AM

Answers

  • Hi

    You will have to create a new view (from your SharePoint list) based on the filter you are trying to set. Once saved switch to that view and choose 'Export to Spreadsheet' - that should only take the items listed on your current view.

    • Marked as answer by Indepth Tuesday, January 14, 2020 3:29 AM
    Tuesday, January 7, 2020 3:10 PM

All replies

  • Hi

    You will have to create a new view (from your SharePoint list) based on the filter you are trying to set. Once saved switch to that view and choose 'Export to Spreadsheet' - that should only take the items listed on your current view.

    • Marked as answer by Indepth Tuesday, January 14, 2020 3:29 AM
    Tuesday, January 7, 2020 3:10 PM
  • Thank you Tina. I am going to try that some time today. 
    • Edited by Indepth Tuesday, January 7, 2020 10:11 PM
    Tuesday, January 7, 2020 10:04 PM