I'm trying to filter using the name of the sheet using the following common Excel Formula:
=MID(CELL("filename"),FIND("]",CELL("filename"))+1,255)
This formula works if put into a cell not related to JET.
The JET report itself also works if I type in the value directly, actually "07" in text.
However, if I use it in a cell which is in the range of an NL() "Filters=" clause:
- JET takes an awfully long time to refresh
- The formula result is not displayed, but the formula is
- The report stops working and usually crashes Excel
I have tried all sorts including:
- Calculating the formula in another cell and referencing that cell
- Using NP("Eval","=FORMULA_ABOVE")
- Using NP("Formula","=FORMULA_ABOVE")
Any ideas, or is this simply not possible?