community postIntegration & APIscommunity - not Microsoftreviewed - checked by Opus

D365 Business Central: How to fix Edit in Excel Add-In Error - The service required to use this feature is turn off. Check your privacy settings.

The Edit in Excel feature in Business Central may show an error message about a disabled service due to privacy settings in Excel. Users can resolve this by enabling optional connected experiences in Excel's Trust Center settings.

post That NAV Guy

Teddy Herryanto · 2025-10-14 · 114 words · about 1 min

"It lets you open records directly in Excel, make quick edits, and publish them back to Business Central."

Key points

  • Edit in Excel allows direct editing of Business Central records in Excel and republishing changes
  • The error occurs when a required service is disabled due to privacy settings
  • The fix involves enabling optional connected experiences in Excel’s Trust Center
  • Users must restart Excel after changing privacy settings for the change to take effect

Quotes

  • “It lets you open records directly in Excel, make quick edits, and publish them back to Business Central.” (Explains the core functionality and value of the Edit in Excel feature for users)

Context

  • Features: Edit in Excel, Excel Add-In

Source: That NAV Guy, community blog. Summary, key points and quotes are derived (CONTENT-NOTICE.md); read the original for the full text.