web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Edit in Excel -- Warni...

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

Suggested Answer

Edit in Excel -- Warning about 1000000 Cell Limit

(1) Share

Report

Report

Posted on by JE-20081519-0

3,797

Hi:

Yesterday, I was trying to use Edit in Excel to copy and paste data from one field into another in the Item Cards screen.

But, a message displayed saying that Edit in Excel had reached its 1000000 cell limit.

Is there a safe "fix" for this?

Thanks!

John

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Yash_Mistry 339 on at

Like (1)

Report
Copy link

Link copied!

Hello,

Yes, there is a limitation when using Edit in Excel.

I have two suggestions:

1. Apply filters on the page to reduce the number of rows being exported to Excel.
2. If you still need to update the data in bulk, you can use a Configuration Package for that purpose.

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

Hope this helps resolve your issue.
If this solution was helpful, please consider marking it as Verified Answer.

Thanks,
Yash Mistry

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

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

#1

OussamaSabbouh 1,831 Super User 2026 Season 1

#2

YUN ZHU 1,122 Super User 2026 Season 1

#3

Khushbu Rajvi. 690 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans