what are you developing, a standalone app? an Excel solution?
"imports data from Excel" to what ?
I would guess you are reading the cell which contain a FORMULA aka: fx
OR function that is not available to your "APPLICATION" (ex. a UDF
(User Defined Function). the solution would then be to read the
I cannot recall thje exact format, but if you type something like
application or worksheet function followed by a period and then the
excel function name, it will then use the excel function
On Nov 4, 7:49 am, Howie wrote:
> I am developing an application which imports data from Excel. A few
> c
Hi,
Try below mentioned options:-
1) Select the cell which has #NAME in it, press F2 and then press Enter.
OR,
2) Check if the formula / function required ATP (Analysis Tool Pack) to be
installed. Go to Tools -> Add-Ins -> and check both the options for ATP,
click ok and it should be done. OR,
3)
