I have a spreadsheet in which I'm suppose to fix up broken formulas. Does anyone know what this is 'meant' to do?
=#REF!A33
+6
A:
that means there was a reference to a worksheet or a named range that has been deleted
in other words it may have been
=Worksheet2!A33
but Worksheet2 has been deleted
possibly nearby cells have similar formulas that still point to a valid location and you can recreate what it pointed to...
MikeW
2009-04-21 23:45:28
+1
A:
Invalid cell reference errors occur when a spreadsheet formula contains incorrect cell references.
See: http://spreadsheets.about.com/od/formulatips/qt/REF_error.htm
Rob
2009-04-21 23:45:31
+1
A:
It probably was referencing a cell on another sheet which got deleted
so
=Sheet1!A33
becomes
=#REF!A33
DJ
2009-04-21 23:46:26