Skip to main content

Notifications

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

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

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 229,918 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans