Trying to evaluate the following kind of formulae:
 | | |
| Code: INDIRECT(B2) SUM(INDIRECT(B2)) | |
| | |
where B2 contains text like "Sheet2!A1:A15" or only even "A1:A15".
For both cases (same sheet and different sheet) Excel evaluates to the correct Values, whereas EasyXLS evaluates to a #VALUE error.
How can that be fixed?
Thanks in advance.