mibuso.com
Home› NAV/Navision Classic Client

OLE Control Error

jungleboyjungleboy Member Posts: 48
edited 2006-08-25 in NAV/Navision Classic Client
Dear All,

One of our customer experience the following error:'This message is for C/AL programmers: An exception was raised in method CreatePivotTable. The OLE control or Automation server returned error (HRESULT)-2147352567. The component did not provide the exception description.

This happen when they try to export the analysis view to excel.

Thank you

Comments

  • ara3nara3n Member Posts: 9,257
    does this happen on every client or just one? can you recreate it on your computer?
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • DenSterDenSter Member Posts: 8,307
    I'd say you need to install Excel on the machine that this happens.
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • Miklos_HollenderMiklos_Hollender Member Posts: 1,598
    Hm... if Excel is not installed, wouldn't this error come earlier, such as at OpenWorkBook or something like that?
  • kinekine Member Posts: 12,562
    May be that just Pivot Table functionality is not installed...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • ara3nara3n Member Posts: 9,257
    Or it' a different (older) version of excel that the SDK didn't have pivot tables in.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • miltonlimiltonli Member Posts: 3
    Hi Jungleboy,

    Do you find the reason for your Error?

    One customer had the same error as yours Todya. And I found the reason:
    The export excel file is too large. The row number is bigger than the Excel file row number limit. The excel file can have no more 35536 rows. But the export excel file’s line number is exceed limit for excel file.

    I think this information will help you.

    Milton
  • jungleboyjungleboy Member Posts: 48
    Hi Miltonli,

    Thanks for the info. But I don't think this is the problem because the analysis view they trying to export doesn't constitute more than 35536 lines.

    After they restart the machine, it was ok.

    TQ
  • PhennoPhenno Member Posts: 630
    jungleboy wrote:
    Hi Miltonli,

    Thanks for the info. But I don't think this is the problem because the analysis view they trying to export doesn't constitute more than 35536 lines.

    After they restart the machine, it was ok.

    TQ


    AFAIK, excel can have no more that 65536 rows...
Sign In or Register to comment.