web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Business Central - Edi...
Small and medium business | Business Central, N...
Suggested Answer

Business Central - Edit in Excel - fields missing

(0) ShareShare
ReportReport
Posted on by bc_new_boy

We are trying to edit some fields on the item card using the edit in excel function but it is not showing one of the fields.

We have managed to add the column using the design function, but it is now not allowing us to edit it because it says it is read only.

Does anyone know how to make any added columns editable?

pastedimage1674055124776v1.png_2D00_640x480.png

I have the same question (0)
  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 11,423 Super User 2026 Season 1 on at

    hi

    look this

    community.dynamics.com/.../842924

    DAniele

  • bc_new_boy Profile Picture
    bc_new_boy on at

    Thanks Daniele - I've followed that and we have managed to add in the necessary fields however they don't seem to be editable - whenever we make an edit and try and publish it comes up that the field we have added through the designer option is read only.

    If you have any other ideas it would be very helpful!

  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 11,423 Super User 2026 Season 1 on at

    look this

    learn.microsoft.com/.../across-work-with-excel

  • bc_new_boy Profile Picture
    bc_new_boy on at

    Thanks Daniele - this is helpful.

    Would you have any idea why some fields pull through from Business Central as read only and whether anything can be done so that these can be edited in Excel?  I can't find any specific information regarding this on the article you shared.

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

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,713 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,032 Super User 2026 Season 1

#3
Grigorios Mavrogeorgis Profile Picture

Grigorios Mavrogeorgis 914 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans