Excel crashed when opening some files saved by library

Excel crashed when opening some files saved by library

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

• 

  yyoshimura

  • Post Options:
  • Link
    Copy

  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

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 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.

• 

  yyoshimura

  • Post Options:
  • Link
    Copy

  Posted 23 March 2021, 11:43 am EST - Updated 29 September 2022, 6:36 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.
  
  

  

  1538×1160 59 KB

  The Excel version is as following.
  
  

  

  1019×109 5.27 KB

  This is the file saved at our end.
  
  EXP_INP02_saved.zip

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 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.