Hi Adrian,
Is it posible to remove (ignore) the error conditions on cells in a flexcel report.
I have a flexcel template with 3 excel tables.
The 1st, _Status_ , is at D8:F9
The 2nd, _Dates_ , is at D13:F14 (underneath the first table)
The 3rd, _Items_ , is at H8:I9 (alongside the first table)
In the first table:
D8 has a tag: <#Status.Desc>
E8 has a tag: <#Status.Code>
F8 has a formula: =COUNTIF(__NewVehs__[Status Flag],E8) (NewVehs is a range on another sheet)
In the second table:
D13 has a tag: <#Dates.Date>
F13 has a formula: =COUNTIF(__NewVehs__[Date Added],D13)
In the third table:
H8 has a tag: <#Items.Desc>
I8 has a formula: =COUNTIF(__NewVehs__[Item Code],H8)
The 3 tables are essentially showing different counts of the data in the NewVehs table)
The
report runs perfectly, the tables expand down correctly, but in the
final excel file, all the formula cells are marked with the green error
triangle - with the error "This cell is inconsistent with the column
formula"
I'm not sure whether I've
configured my template incorrectly, and it's that causing the cells to
be flagged as errors, or, if the template is ok, is it possible to
hide/ignore these errors in the final excel file before I save it?