Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Answered

Open Item List in Excel - Extremely slow

Posted on by 501
Hi, 
Our Business Central is on SAAS 24.4.
 
Since the minor upgrade we had some difficulties in our production environment to Open the Item List in Excel using standard functionality. 
The report runs for 30min + before creating the Excel File. 

We made a copy of production with the latest version of BC to a Sandbox Environment. The Export was less than 5 seconds. 

We Restarted Production but with no success,
All the apps are updated to the latest versions. 
The Environment has enough storage capacity
We tried it after hours with only one user working on the Environment

Any advise to resolve this will be highly appreciated. 
Categories:
  • Verified answer
    YUN ZHU Profile Picture
    YUN ZHU 73,696 Super User 2024 Season 2 on at
    Open Item List in Excel - Extremely slow
    Is there any customization? You can use the following function to test which extension is causing this problem.
    Also, what is the number of Item table?
    Can it be exported using Configuration Package?
     
     
    Thanks.
    ZHU
  • gdrenteria Profile Picture
    gdrenteria 12,183 Most Valuable Professional on at
    Open Item List in Excel - Extremely slow
    Hi
    I hope this guidelines could help you
    Best
    GR

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans