Excel crashed when opening some files saved by library

Posted by: yyoshimura on 22 March 2021, 12:51 pm EST

  • Posted 22 March 2021, 12:51 pm EST

    Hi

    We have some files that are crashing when opened in Excel. These files were saved using the latest version of library. Please refer attachment for reproduction. We noticed that the formula in [Input] sheet starting E834 cannot be obtained using VBA or program. When scrolled to rows beyond 834, Excel will become very unstable and crash very often. The file cannot be saved as new file due to lengthy formula error.

    Please help to investigate this issue. Thank you.

    Regards

    gcexcelperformance.zip
  • Replied 22 March 2021, 8:19 pm EST

    Hi Yukinori,

    The sample is working fine at our end and the saved excel file is opening fine too without any error.
    Are there any specific steps to reproduce the issue?
    If not can you please let us know the VS version that you are using and the Excel version in which you are opening the saved excel?

    Regards,
    Prabhat Sharma.
  • Replied 23 March 2021, 11:43 am EST

    Hi

    This problem can be confirmed at our end with multiple environments. There is not specific steps other than running the sample program and open the saved [EXP_INP02_saved.xlsm] file multiple times. The saved file is not crashing all the time. If we open it several times, there is great chance to crash. If we try to saved the file as new file, sometimes a warning dialog saying some formulas are beyond 8192 characters and cannot be saved or Excel crashes immediately.

    By the way, the VS version is as following.


    The Excel version is as following.


    This is the file saved at our end.
    EXP_INP02_saved.zip
  • Replied 23 March 2021, 9:11 pm EST

    Hello,

    We have escalated this to the developers and will let you know as soon as we get any update on this from the developers' end.
    [Internal Tracking Id: 3894]

    Regards,
    Prabhat Sharma.
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels