Support has indicated that the ‘Edit in Excel’ option is automatically added to list pages in Business Central. It doesn’t always make sense for it to be there and it doesn’t even always work. There are several pages where it exists and does not work or display the proper data. Since this page is building a report on the fly it’s not something that will translate through to ‘Edit in Excel’ which is using the Dynamics Excel Add-in.
The Edit in Excel should be removed as an option and an Export functionality added so that the results can be exported or printed so that it can be shared with others.
Comments
Dimensions are powerful tools in Dynamics, and the functionality for analysis seems very poor in BC as compared to NAV. As an example, when I do try and export an analysis by dimension report from BC, I would expect to see similar functionality to NAV; A pivot table I can then modify. However, all I can get out of it is unusable and full of (what should be hidden) dates etc.
Category: Financial Management
The Analysis by Dimension is very powerful, but with no means of exporting the results to Excel or to a report format. This is critical in the use of this functionality.
Category: Financial Management
Business Central Team (administrator)
Thank you for your feedback. We released this feature as part of the functionality in October 2018 release of Business Central.