There is an unsaved comment in progress. You will lose your changes if you continue. Are you sure you want to reopen the work item?
Cannot re-save due to Formula Length Longer than 8192 characters
I've created a spreadsheet using EPPlus. It opens fine (I use Excel 2016), but when I try to save it I get the error message:
"One or more formulas in this workbook are longer than the allowed limit of 8192 characters. Cell 'Rooms!B2' contains one of these formulas. To avoid this limitation, save the workbook in the Excel Binary Workbook'"
The formula in Rooms!B2 is:
=IF(A2<>"", COUNTIFS(Participants!D2:D112, A2, Participants!I2:I112, "Boy"), "")
which is obviously less than 8192 characters long.
If I delete and re-enter the formula then I can save the spreadsheet, so it appears to be some thing about how EPPlus is writing the formula.