
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!


Coordinator
Aug 10, 2016 at 5: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 ?

