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... / Microsoft Dynamics Off...
Small and medium business | Business Central, N...
Suggested Answer

Microsoft Dynamics Office Add-in

(2) ShareShare
ReportReport
Posted on by RH-08081619-0 4

I am trying to link data between Dynamics 365 Business Central and Excel.

The Dynamics data connector is installed in my Excel and all BC settings are completed.

I have ran repair on my Office install.

The function I'm trying to do with the add-in is to "edit" Business Central lists in Excel to publish back changes. At first, I get an error that I don't have permissions, then I get the add-in to work but only have the "design" function, no refresh or publish (like the data isn't connecting). 

 

It was working fine until Wednesday Aug 6th 2025, then eveyone in our office is having the same issue

Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    Sumit Singh Profile Picture
    Sumit Singh 10,079 on at
    Your issue—where Edit in Excel only shows the "Design" pane and not "Refresh" or "Publish"—is likely caused by a known bug introduced in Business Central version 26.1, which was released just before August 6th, 2025.

    Observations:

    • The issue started exactly on August 6th, aligning with the BC v26.1 rollout.
    • Multiple users across environments reported that Edit in Excel stopped working, showing only partial functionality [1].
    • The Data Connector pane either fails to load or lacks the expected buttons (Refresh, Publish).
    • This is not a permissions issue, but a version-specific bug.

    Confirmed Fix

     Upgrade to Business Central v26.2

    • Microsoft has acknowledged the issue and released a fix in BC v26.2.
    • After upgrading, the Edit in Excel functionality is fully restored, including:
      • Refresh
      • Publish
      • Proper Data Connector pane behavior
    This fix has been confirmed by multiple users and partners [1].

    Additional Checks (If Upgrade Isn’t Immediate)

    If you cannot upgrade right away, try these interim steps:

    1. Check Add-in Status in Excel

    • Go to File → Options → Add-ins
    • At the bottom, choose Manage: Disabled Items → Go
    • Ensure Microsoft Dynamics Office Add-in is enabled

    2. Sign In to the Connector

    • Open the Excel file
    • If the Data Connector pane is blank, click Sign In
    • Use your Business Central credentials

    3. Try Excel Online

    • Use Edit in Excel via browser (Excel Online) as a temporary workaround [2]
    Summary
    Issue Cause Fix
    Edit in Excel missing Refresh/Publish Bug in BC v26.1 Upgrade to BC v26.2
    Permissions error Possibly due to Office 365 policy Confirm add-in is enabled
    Data Connector not loading Local Excel issue or sign-in required Reinstall add-in or use Excel Online
    References
    [1] Solved: Edit in Excel no longer working - Post BC v26.1
    [2] Edit in Excel - side panel (data connector) missing
    Note: This response was created in collaboration with Microsoft Copilot to ensure clarity and completeness. I hope it helps to some extent.
    Mark the Answer as Verified if this is Helpful.
     

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