![]() ![]() That causes references to _xlfn.IFNA and IFNA to result in #NAME errors. However, when we click Enable Editing, that triggers a recalcuation cycle. So before clicking Enable Editing, you see the last values calculated when the file was saved. Usually, when Excel opens a file, it does not recalculate unless circumstances require it (e.g. I do not understand why only some references to IFNA are converted.) So when I open the Excel file in Excel 2010, I see _xlfn.IFNA to indicate an unsupported function. IFNA is supported in only certain versions of Excel. ![]() Finally, click Close to close the dialog box. Then, enter IFNA into the Find field, and click Replace All.Ħ. First, enter _xlfn.IFNA into the Find field, and click Replace All.ĥ. Press ctrl+h to open the Find and Replace dialog box.Ĥ. After clicking Enable Editing, do the following:Ģ.
0 Comments
Leave a Reply. |