Small and medium business | Business Central, N...

Filters/data not adding into excel sheet

(3) Share

Report

Posted on by TJ-26020717-0

When working with filters and wanting to pull the data out in a excel sheet. It's not adding the data into my excel sheet.

Is it a default, or am i able to change these settings somewhere?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (0)

TJ-26020717-0 12 on at

Like (1)

Report

Filters/data not adding into excel sheet

Hi thank you for your response. I'm using the function 'Open in Excel' But the filters that i have chosen, are not following into the Excel sheet.

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 19,131 Super User 2025 Season 2 on at

Like (1)

Report

Filters/data not adding into excel sheet

If it provide some hint: https://answers.microsoft.com/en-us/msoffice/forum/all/why-excels-filter-doesnt-work/03741bd7-293e-415b-b3de-c4c287596294

https://answers.microsoft.com/en-us/msoffice/forum/all/excel-adding-new-data-filter-does-not-work/bb821992-73de-4d85-b725-57e45edfa8b4

https://answers.microsoft.com/en-us/msoffice/forum/all/not-able-to-click-on-filter-symbol-to-filter-data/a5f033df-4c27-4228-824c-7fe6c71762b8

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 91,943 Super User 2025 Season 2 on at

Like (0)

Report

Filters/data not adding into excel sheet

Did you use the Open in Excel function?

If so, this problem should not occur and only the data displayed on the page will be exported.

If it is a Configuration Package, you need to add a filters first.

Hope this can give you some hints.

Thanks.

ZHU

Was this reply helpful? Yes No
Martin Dráb 236,160 Most Valuable Professional on at

Like (0)

Report

Filters/data not adding into excel sheet

Moved from Integration, Dataverse, and general topics forum to Small and medium business | Business Central, NAV, RMS forum.

Was this reply helpful? Yes No
TJ-26020717-0 12 on at

Like (0)

Report

Filters/data not adding into excel sheet

I'm using Dynamics 365 Business Central (Abakion)

Was this reply helpful? Yes No
Martin Dráb 236,160 Most Valuable Professional on at

Like (0)

Report

Filters/data not adding into excel sheet

Which D365 product are you using? The D365 brand covers quite a few things, such as Finance and Operations, Business Central or Customer Engagement.

Was this reply helpful? Yes No