Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

Edit in Excel limit reached-Increase refresh limit

Posted on by 501

Hi, 
I created a Bom Component list page in a SAAS environment. The Page will be editable in excel. 
There is roughly 240,000 rows with around 10 columns.

I received an error that the cell refresh limit of 1 000 000 cell has been reached. 

pastedimage1678253342030v1.png

Question:  Is there a way to increase the 1 million cell refresh limit?  Also, why is the refresh limit added, does it have something to do with table locks and performance of BC?

  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at
    RE: Edit in Excel limit reached-Increase refresh limit

    Thank you for sharing.

  • Hein Kruger Profile Picture
    Hein Kruger 501 on at
    RE: Edit in Excel limit reached-Increase refresh limit

    Microsoft reply: (In short edit in excel limit has been reached.)

    As discussed during the call operational limits for BC Saas are not editable, because they ensure stable performance both for your tenant and the the others that are sharing the same resources.

    Performance in Business Central Online - Business Central | Microsoft Learn

     pastedimage1678356295139v1.png

    As promised I am sharing the GitHub page on operational limits and the tips how to manage some of them form our development: 

    dynamics365smb-devitpro-pb/operational-limits-online.md at main · MicrosoftDocs/dynamics365smb-devitpro-pb · GitHub

     pastedimage1678356299919v2.png

    The best way to move past the limit will be to rearrange the Bom page and split it if possible in order to be within the limits. 

    Below is the scope for your support request: 

    Issue:
    Partner reported on Dynamics 365 Business Central Online, that he created a Bom page with 240 000 rows and 10 columns but when he runs the page in edit in excel a refresh on the cells is hit and would like to know if there is any way to change the operational limits and why they are in place. 

     


    Scope:
    The case will be considered resolved, when “we provide assistance in troubleshooting the issue, which is not configured/working correctly:
    Partner reported on Dynamics 365 Business Central Online, that he created a Bom page with 240 000 rows and 10 columns but when he runs the page in edit in excel a refresh on the cells is hit and would like to know if there is any way to change the operational limits and why they are in place.  
    , or we provide official explanation, regarding experienced system behavior.

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,339 Super User 2024 Season 2 on at
    RE: Edit in Excel limit reached-Increase refresh limit

    Hi, hope the following helps.

    Summary of where to file bugs and issues

    https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/technical-support#summary-of-where-to-file-bugs-and-issues

    Thanks.

    ZHU

  • Hein Kruger Profile Picture
    Hein Kruger 501 on at
    RE: Edit in Excel limit reached-Increase refresh limit

    yzhums  thank you for your reply.

    How do I raise a SR with Microsoft?

    Thanks

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,339 Super User 2024 Season 2 on at
    RE: Edit in Excel limit reached-Increase refresh limit

    Hi, in MS Docs, there is only a limit on the number of rows, and no limit on the number of Cells.
    I recommend raising an SR to Microsoft.

    https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/operational-limits-online

    https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/api-reference/v2.0/dynamics-current-limits

    pastedimage1678335143769v1.png

    Hope this helps.

    Thanks.

    ZHU

  • Hein Kruger Profile Picture
    Hein Kruger 501 on at
    RE: Edit in Excel limit reached-Increase refresh limit

    Hi Marco Mels, the problem is not the amount of records but the amount of cells.

    Thanks

  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at
    RE: Edit in Excel limit reached-Increase refresh limit

    Helllo,

    One mio records it the current limit to my knowledge. Increasing this limit does not seem to make much sense as Excel has a limit of 1,048,576 rows.

    Hope it explains the message. Thank you.

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans