Skip to main content
Business Central forum
Suggested answer

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

editSubscribe (0) ShareShare
ReportReport
Posted on by 3,476

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.

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,066 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,585 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans