I have a report and I need to calculate the value of a cell prior to the jet calculation.
I put this in a cell:
=NP("Evaluar";"=CELDA(""FILENAME"";N30)")
But it doesnt' work, it returns #¡VALUE!
However =CELDA("FILENAME";N30) returns dg in another cell. So it fail when I put the formula in an NP-Evaluate.
What's the problem?
Hello Pablo -
i tried to duplicate what you described, but it worked for me:
Since your sheet is displaying !VALUE#, you can try to select that cell and then click the Check Error button on the Jet ribbon. That may provide some additional information about the error.
If that doesn't help, you can try submitting a support request with the Jet Tech Support Team.
