Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Business Central forum / 'Edit in Excel'...
Business Central forum

'Edit in Excel' functionality

(0) ShareShare
ReportReport
Posted on by Dynamics 365 Busine... 700

Hi All,

We are trying to explore the 'Edit in Excel' functionality in D365 Business Central, but facing some issues. 

Whenever we add a custom field in any form (through extension development) and open that particular page in Excel for editing purpose, that newly added custom field is not displayed in the excel sheet.

Moreover, the value which we enter in that custom field through the UI, also not getting displayed on the Excel sheet.

Can you please suggest a way to resolve this issue.

Thanks in advance !

Categories:
Business Central
Other
  • Dynamics 365 Business Central Profile Picture
    Dynamics 365 Busine... 700 on at
    RE: 'Edit in Excel' functionality

    1665.TimeSheetTbl.pngI have added fields to the Report Dataset already but not able to add only that field (working hours) as I am unable to get the name of that field. I have already gone through the document link you provided. Please find the attached screenshot for more details. I need to display the highlighted part.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: 'Edit in Excel' functionality

    I'm afraid you can't add fields to a Report Dataset as of yet.

    Interesting post about this: thinkaboutit.be/.../

  • Dynamics 365 Business Central Profile Picture
    Dynamics 365 Busine... 700 on at
    RE: 'Edit in Excel' functionality

    Thanks !

  • Community Member Profile Picture
    Community Member on at
    RE: 'Edit in Excel' functionality

    No problem, glad I could help!

  • Dynamics 365 Business Central Profile Picture
    Dynamics 365 Busine... 700 on at
    RE: 'Edit in Excel' functionality

    Can you please help me out with one more issue related to Time Sheet ! Need to display the working hours of an Employee (day-wise) in a report. Report creation has been done but this field is not getting displayed.

  • Dynamics 365 Business Central Profile Picture
    Dynamics 365 Busine... 700 on at
    RE: 'Edit in Excel' functionality

    Thank You Kasper. It works ! :)

  • Verified answer
    Community Member Profile Picture
    Community Member on at
    RE: 'Edit in Excel' functionality

    Hi,

    Did you try the 'Design' mode in the Excel Add-in? It allows you to add missing fields.

    See this post: community.dynamics.com/.../edit-in-excel-functionality

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,245 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,925 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans