.Formula or function cannot find the reference data.
Answers
Answered by
1
Answer:
Just press Ctrl+F to display the Find tab of the Find and Replace dialog box, then search for the # character. Make sure you tell Excel to do its searching within Formulas. Inspect anything that is found to see if it is an error or not. You should also take a look at any named ranges defined in your workbook
Answered by
0
Answer:
Excel found a problem with one or more formula references in this worksheet. Check that the cell references, range names, defined names, and links to other workbooks in your formulas are all correct.
Similar questions