Skip to main content

Notifications

Announcements

No record found.

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

Export Aged Accounts Payable to Excel from Business Central -- "Macro" Warning

(0) ShareShare
ReportReport
Posted on by 3,482

Hi:

How do I completely get rid of the warning in Excel about macros, upon exporting the Aged Accounts Payable from the "Excel" section of the Business Central Role Center?

Thanks!

John

  • Suggested answer
    Amit Baru Profile Picture
    Amit Baru 3,025 on at
    RE: Export Aged Accounts Payable to Excel from Business Central -- "Macro" Warning

    Hi,\

    Pls contact with your IT Administrator regarding this issue. This is Excel Or Permission issue in your system.

    Regards

    Amit Sharma

    www.erpconsultors.com

    https://www.linkedin.com/in/amit-sharma-94542440/

  • Alfredo_Iorio Profile Picture
    Alfredo_Iorio 1,260 on at
    RE: Export Aged Accounts Payable to Excel from Business Central -- "Macro" Warning

    The warning comes from your machine and Excel issue. This is not a BC issue.

    You can disable the Macros warning in Excel, but that warning will never show even if there are macros in an Excel file you open from an email.

    I do not recommend that.

  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at
    RE: Export Aged Accounts Payable to Excel from Business Central -- "Macro" Warning

    Hello,

    This may help:

    support.microsoft.com/.../change-macro-security-settings-in-excel-a97c09d2-c082-46b8-b19f-e8621e8fe373

    Best is probably not to lessen the security unless you are certain that it is safe.

    Thank you.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans