Invalid References

**dblcrona** · 02-21-2011, 12:26 PM

I keep getting an error that A formula in tgis worksheet contains one or more invalid references. Verify that your formulas contain a valid path, workbook, range name, and cell reference.

If Excel is smart enough to know this why doesn't it tell me which formula has an invalid reference? Is there a way to find it without looking at every single formula?

**brokenbiscuits** · 02-21-2011, 12:35 PM

Presumably this would be bringing back a #REF error in the cell, so if you do a ctrl+F search for #REF (making sure you're looking in values, not formulas in options) you should be able to find the cell(s) causing the problem?

**dblcrona** · 02-21-2011, 12:59 PM

Originally Posted by brokenbiscuits

Presumably this would be bringing back a #REF error in the cell, so if you do a ctrl+F search for #REF (making sure you're looking in values, not formulas in options) you should be able to find the cell(s) causing the problem?

I figured it out. The formula was pointing to a blank cell which is why I didn't get a #REF. Problem solved.