Public Profile
  • Analysis By DImension Export to Excel Remove Edit in Excel

    The Edit in excel doesn't work on the 'View - Analysis by Dimension Matrix' page and there is no means of exporting to Excel. 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.