News and Announcements icon

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

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

Suggested answer

Edit in Excel - turn off field validation?

(1) Share

Report

Report

Posted on by October Sky

202

Is it possible to turn off field validation when using the Edit in Excel feature on BC?

I know it can be done using configuration package but I want to know for sure using Edit in Excel.

For example, say the phone # field allows only digits but contained some text. Could you turn off such a validation check in edit in excel?

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

YUN ZHU 75,595 Super User 2024 Season 2 on at

Like (2)

Report

Edit in Excel - turn off field validation?

Unfortunately, there is no way as far as I know.
You can turn off Validation in Configuration Package, but not in Edit in Excel.

Thanks.

ZHU
Suggested answer

VaHiX 3,604 on at

Like (3)

Report

Edit in Excel - turn off field validation?

Please check these tutorials:

Add, change, or remove data validation - Microsoft Support

Remove the validation of a field - Dynamics 365 Business Central (usedynamics.com)

** Please don't forget to close up the thread here by Like and verify it as an answer if it is helpful **

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,371 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans