Limiting Columns When Using 'Edit in Excel' Feature

(1) Share

Report

Posted on by S Bell

When using the 'Edit in Excel' feature on the General Journal page, I notice that the Excel file contains different columns to those that I have visible within Business Central.

I've seen a good amount of information online suggesting that this is to be expected, but my only reason for creating this post is that the documentation from Microsoft themselves suggests that columns should be inherited. The following link states /With this action, Excel respects most filters on the page that limit the records shown, so the Excel workbook will contain almost the same records and columns./ in relation to the Edit in Excel feature: https://learn.microsoft.com/en-gb/dynamics365/business-central/across-work-with-excel.

I'd be grateful if anyone can confirm if I'm missing something, or perhaps the Microsoft documentation is misleading here?

Many thanks,

Simon

Categories:

Business Central

All responses (1)

Answers (0)

ahanson 174 on at

Like (0)

Report

Limiting Columns When Using 'Edit in Excel' Feature

Simon, I can just speak to experience that edit in Excel definitely does not show all columns visible. The best way to edit more or all columns is to do a configuration package. You can include all fields in the table or limit it down and apply filters.