Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

An Exception was raised in method Range. The OLE Control or Automation Server has returned error (HRESULT) - 2147352567. The component could not provide the exception description.

Posted on by 2,558

Refer to title above, it show when export data to excel. Any solution regarding this issue?

*This post is locked for comments

  • Verified answer
    Neville Foyn Profile Picture
    Neville Foyn 4,320 on at
    RE: An Exception was raised in method Range. The OLE Control or Automation Server has returned error (HRESULT) - 2147352567. The component could not provide the exception description.

    Hi

    There is unfortunately no simple solution to this error message,

    (I have tried to explain this simply so to the very technical excuse the terminology)

    What it means is that NAV is trying to work with an external program (In this case Excel) and is unable to find the "Automation Server"

    This is the bit of software that provides the translation between NAV an Excel, this error means that in the NAV code it is looking for that bit of software and cannot find it

    A couple of reasons that this can happen:

    The version of Excel used in the development of the NAV component is newer than the one used on this PC

    The PC had a faulty or incomplete installation of Excel

    There is a problem with the NAV install

    The PC's windows install is faulty and the only solution might be a format and re-install

    The above are things are all items i have found that cause this problem

    Hope this helps

    Nev

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 Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans