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?
Thank you for sharing.
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:
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.
Hi, hope the following helps.
Summary of where to file bugs and issues
Thanks.
ZHU
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.
Hope this helps.
Thanks.
ZHU
Hi Marco Mels, the problem is not the amount of records but the amount of cells.
Thanks
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (