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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Unanswered

Excel-layouts lost data connection after version update!

(0) ShareShare
ReportReport
Posted on by 144

Hi,

we have created over 50 Excel layout reports under BC 20.x OnPrem, which all worked fine. After the update to BC 21.6 OnPrem, we noticed that the reports were not updated when they were called. There was no error message, but the data table is empty (more precisely, the data table only contains the data that was contained in the last Excel layout save) and i found no Data-Connection.

After some experimenting we found a workaround:

  1. In Page 9660 we clicked on "Edit Info" in the reports. Here comes the message: It is not possible to modify the layout ... because it is provided by an extension ... Do you want to edit a copy of the layout instead?"
  2. Here we clicked on "Yes" and thus created a copy of the layout.
    If I now click on "Run Report" here, the Excel file is downloaded and the data has been updated as desired.
  3. So I downloaded the copy via "Export Layout".
  4. I then used the copy to overwrite the old Excel layout in the APP and then republished the APP. After that, the original report was updated again when it was run.
  5. Then I deleted the copies on page 9660 again.

This looks like a BUG to me!?
Even if I found a workaround for myself here, I naturally ask myself whether this will happen again with the next update and whether it is a BUG or whether something in our environment is not OK?

Can any of you reproduce this?

greeting
Ralf

I have the same question (0)

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 702 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 481 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 328 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans