Excel crashes on autosave, when formula is used

May 27, 2016 at 3:48 PM
Hello all - Creation and opening of excel works great, however, when I insert this formula into a sheet, the file will crash upon autosave (at 10 minutes or so), and try to recover. Without the formula, it's fine.

$sheet.Cells["E4:E400"].Formula = "IFERROR((L4/(VLOOKUP(B4,Pricecheck!C4:M406,11,0)))/4,"""")"

Any assistance is appreciated!
Aug 10, 2016 at 6:28 AM
If the problem occurs during "autosave", I think that this is the formula that's causing your problem. When you work with formulas in Excel, Excel validate these at input, with OOXML you can set what you want as formula. To be sure, could you give me an Excel document with this problem ?