Excel Run Time Error

csimoneauxcsimoneaux Member Posts: 168
edited 2008-11-13 in Navision Attain
I have been running an export to excel report for over a year and now I am getting a error message...
Microsoft Visual C++ Runtime Library
Runtime Error!
Program C:\Program Files\Microsoft Office|OFFICE11\EXCEL.EXE

abnormal program termination.

This work just fine on Friday.
Any Ideas...ANYone.....Help

Comments

  • SavatageSavatage Member Posts: 7,142
    I would simply reinstall excel to see if that fixes the problem. I like to try the obvious & easiest solutions first :lol:
  • csimoneauxcsimoneaux Member Posts: 168
    been there...done that.

    I am using MS Office Excel 2003(11.5612.5606) Standard edition 2003

    Running Nav 3.7...yes we are about to upgrade.
  • SavatageSavatage Member Posts: 7,142
    nothings changed since friday? cache change? anything? did you just to a reinstall or a complete UNINSTALL & then reinstall. sounds odd..is it definately a nav error or an excel crashing type of error?

    does it work with smaller reports? is this a huge report? perhaps the # of lines has been exceeded?
  • csimoneauxcsimoneaux Member Posts: 168
    Smaller version of this will work, but this no does not exceed 65,000 lines.
    I have asked and asked and all of IT says that there were no new changes or upgrades.
    I can not take that statement to the bank.

    Other ideas? I on my own.
  • SavatageSavatage Member Posts: 7,142
    Well excel works fine as you said on a smaller report.

    The only thing I can think of is memory usage. (not enough)

    close all other open apps and all services running on the bottom right of your screen next to the clock.

    or uncheck all start up programs (Start->run->msconfig->startup) reboot and if it works, then you know it's a resource problem.
  • csimoneauxcsimoneaux Member Posts: 168
    This is still not the issue.
    there only 146 line that should be exported to excel.

    HELP>>>ANY one?
  • SavatageSavatage Member Posts: 7,142
    you said it worked fine on a smaller report .. how small is small?

    anyway are there any wacky formulas or strange characters or 1000 columns?
    you're not giving alot of info regarding which reports work & which do not.

    So if this error only occurs on THIS report - you will have to take a hard look at that report.
    perhaps some error is occuring on some variable. Is this a standard report, a custom report?
  • csimoneauxcsimoneaux Member Posts: 168
    Yes, this is a custome report. It is popluating Excel from an AR Aging report. It only populated customers with balances due for only 120 days out.
    This is not the only report with the same exact error.
    I have 4 more reports with the same problem. Each one work last week and now none of them do.
    I have run thes reports on 2 other machines and they all have the same error pop up.
    They seem to die at line...

    TmpExcelBuffer.CreateSheet('Aged AR','Aged Accounts Recivable.','All Companies',USERID);

    Report - OnPostReport()
    //>>001
    IF ExporttoExcel THEN BEGIN
    TmpExcelBuffer.CreateBook;
    TmpExcelBuffer.CreateSheet('Aged AR','Aged Accounts Recivable.','All Companies',USERID);
    TmpExcelBuffer.GiveUserControl;
    END;
    //<<001

    I created these reports about a year ago and now all of my excel reports are poping up with this same error. I have talked to IT but they deny any changes.
    We receintly have a new phone system put in, that used the network and I do not know what they did. Neither does IT.
Sign In or Register to comment.