I have used a formula like below, means when there is sheetname soon after the ‘=’ sign then additional symbol ‘@’ comes it self while exporting the excel.
string strFormula = "IFERROR(IF(MATCH(1,(D1=‘sheet name’!D:D)*…so on
but in excel file this formula comes like:
"IFERROR(IF(MATCH(1,(D1=@‘sheet name’!D:D)*…so on
means extra @ comes itself. so cell formula doesn’t work.
Can someone please help on it,