mibuso.com
Home› NAV/Navision Classic Client

Excel Buffer Range Method Error.

sunnyksunnyk 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

  • garakgarak Member Posts: 3,263
    Did you start the debugger to see, where the error pops up?
    Do you make it right, it works too!
  • sunnyksunnyk Member Posts: 280
    I tried debugger, But when run the report with debugger ON it is taking ages to generate the 1st page itself.
  • kinekine 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.
  • sunnyksunnyk Member Posts: 280
    Yes Kine, You are right.
Sign In or Register to comment.