Runtime Import a sheet having cell formula which refers to other sheet
I am trying to import a sheet in qtp at runtime using datatable.importsheet path, "sheet1", "sheet1"
In Excel sheet, some of the cell formula refer to values from other sheets.
E.g. = if (sheet2!A1="NA", B1, C1)
when these sheets are imported to QTP datasheets, the formula changes to
= if (sheet2!A1="NA", B1, C1)
which result in invalid calculation and displays #N/A as value.