Excel Buffer Range Method Error.

sunnyk
sunnyk Member Posts: 280
edited 2009-05-20 in NAV/Navision Classic Client
Greetings,

I made one of my report Export to excel. When i run this report for few records it runs fine but when i run it without giving any filters it throws following Error.

Answers

  • garak
    garak Member Posts: 3,263
    Did you start the debugger to see, where the error pops up?
    Do you make it right, it works too!
  • sunnyk
    sunnyk Member Posts: 280
    I tried debugger, But when run the report with debugger ON it is taking ages to generate the 1st page itself.
  • kine
    kine Member Posts: 12,562
    sunnyk wrote:
    Greetings,

    I made one of my report Export to excel. When i run this report for few records it runs fine but when i run it without giving any filters it throws following Error.

    May be that you are exporting more rows than excel can handle. Older versions have limit to 64k, Office 2007 have now much higher limit...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • sunnyk
    sunnyk Member Posts: 280
    Yes Kine, You are right.

Categories