web
You’re offline. This is a read only version of the page.
close
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 / Small and medium business | Business Central, N... / Edit in Excel no longe...
Small and medium business | Business Central, N...
Answered

Edit in Excel no longer working - Post BC v26.1

(8) ShareShare
ReportReport
Posted on by Dynamics and Beyond 126
After updating from BC 25.5 to 26.1, the Edit in Excel is no longer populating the information when creating new batch.  Open in Excel is working.  To replicate within BC 26.1, open the Item Journals window, create new Batch Name ie TEST, enter a line completely and navigate to export icon to select Edit in Excel.  Enable Editing if prompted within Excel watching the status complete within the Data Connector window.  The first line of data does not transfer into Excel like previously in BC 25.5.  NOTE - Default batch works where the issue is unique to new batch.
 
 
 
 
 
Issue is able to be replicated in multiple 26.1 environments.
 
Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    Sohail Ahmed Profile Picture
    Sohail Ahmed 11,136 Super User 2025 Season 2 on at
    Hi This is known issue to Microsoft and will be resolved in coming release 26.2
    This issue will be resolved in Business Central release 26.2. Please upgrade to version 26.2 and check if the problem persists. Let us know if you're still experiencing the issue after the update.
     
    ✅ Mark this answer as verified if it helps you.
     
  • Suggested answer
    Jainam M. Kothari Profile Picture
    Jainam M. Kothari 15,631 Super User 2025 Season 2 on at
    This will be resolved in coming release 26.2
  • Suggested answer
    Kamal Khakhkhar Profile Picture
    Kamal Khakhkhar 1,274 on at
    Hii there ,
    In BC 26.2 its solved you can update your environment .
    mark it answered if you found your answer.
     
    Thank you.
    Kamal Khakhkhar
  • Verified answer
    Dynamics and Beyond Profile Picture
    Dynamics and Beyond 126 on at
    Updating to BC v26.2 resolved the bug - confirmed.
  • NL-26110715-0 Profile Picture
    NL-26110715-0 6 on at
    I have a client who is on BC v27 and when she exports to excel via the edit in excel function, she gets the above issue.
    When I do the same process, I am able to connect the spreadsheet to BC. The user has the necessary permissions assigned.
     
    Any reason as to why it works for me and not the user?

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,143

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,694 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,067 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans