I have an issue with EPM Add-in. I have a workbook with several worksheet. one of the worksheet has an EMPRETRIEVEDATA formula.
when I refresh data ->worksheet I get a value X, however when a refresh data -->workbook I get a value Y. X and Y are not the same BUT the intersection is the same. the correct value is X. I am not sure how the Y value is being returned.
May you please assist.
Thanks in advance.