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

Edit in Excel limit reached-Increase refresh limit

(0) Share

Report

Posted on by Hein Kruger

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.

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?

All responses (7)

Answers (0)

Suggested answer

Marco Mels on at

Like (0)

Report

RE: Edit in Excel limit reached-Increase refresh limit

Thank you for sharing.
Hein Kruger 501 on at

Like (1)

Report

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

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

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 73,339 Super User 2024 Season 2 on at

Like (0)

Report

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 501 on at

Like (0)

Report

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 73,339 Super User 2024 Season 2 on at

Like (0)

Report

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

Hope this helps.

Thanks.

ZHU
Hein Kruger 501 on at

Like (0)

Report

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 on at

Like (0)

Report

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.