[CLOSED] ROW-TOTAL, MISSING VALUES, NODATA AND EXL07 FORMULA
So I have a report that outputs to EXL07 FORMULA that has an ACROSS in it. I'd like the ROW-TOTAL option to function correctly but it does not. It throws a #VALUE! error whenever there's a missing value in the row, even when I set a NODATA.
Here's the rub -- it works fine when the sheet first opens. I only throws the error when you save the output or click the Allow Editing option in Excel.
Here's the question -- Has anyone bumped into this and found a solution? It more or less works correctly in EXL2K, but it's ugly and doesn't respect the NODATA option in the display. This appears to be a legit bug in the EXL07 FORMULA output option, and I'd like to know if anyone has seen a workaround. I can't find it in the forums.This message has been edited. Last edited by: FP Mod Chuck,