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

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 (1)
  • Suggested answer
    Sohail Ahmed Profile Picture
    Sohail Ahmed 11,171 Super User 2026 Season 1 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,833 Super User 2026 Season 1 on at
    This will be resolved in coming release 26.2
  • Suggested answer
    Kamal Khakhkhar Profile Picture
    Kamal Khakhkhar 3,244 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 18 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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March 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,969 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,143 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 688 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans