Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Answered

Could not create an instance of the OLE control

Posted on by 5

Hello,
I am hoping someone could provide their assistance with the following error. Many of my colleagues are receiving this error when trying to export a table or form from NAV to Excel.Screenshot-2022_2D00_09_2D00_15-135345.png
We are operating Dynamics NAV 2009 on Windows 10 and Windows 11 machines.
I can confirm the error message appears on both Windows operating systems (W-10 & W-11)

Screenshot-2022_2D00_09_2D00_15-134919.png
Thank you very much in advance.
Regards,

Rachel.

  • Could not create an instance of the OLE control
    Hello Rachel,
    could you please tell me exactly what you did. i have the same problem.
    Thank you
  • Verified answer
    Marco Mels Profile Picture
    Marco Mels on at
    RE: Could not create an instance of the OLE control

    Thank you for sharing final outcome.

  • RACHEL2022 Profile Picture
    RACHEL2022 5 on at
    RE: Could not create an instance of the OLE control

    Thank you for all your assistance.

    We have resolved the error.

    CAUSE:

    Install of new computers with windows 11 do not have old XML 3 DOM installed.

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,698 Super User 2024 Season 2 on at
    RE: Could not create an instance of the OLE control

    Hi, NAV 2019 has been end of life. If you cannot integrate with the latest OS or Office, please upgrade NAV to BC.

    https://docs.microsoft.com/en-us/lifecycle/products/dynamics-nav-2009-r2

    pastedimage1663287460370v1.png

    Hope this helps.

    Thanks.

    ZHU

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,091 Super User 2024 Season 1 on at
    RE: Could not create an instance of the OLE control

    Hi,

    I am not sure now you will have much support for 2009, but can you check if you already installed MS office, and try to re-install the NAV 2009

    Thanks.

  • KTA Profile Picture
    KTA 1,200 on at
    RE: Could not create an instance of the OLE control

    Looks like you excel license isn't registered. Is a local or a terminal server mode?

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,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans