What should this Excel formula do?

Question

I have a table in which I have to fix broken formulas. Does anyone know what it means to do?

=#REF!A33

Answer 1

This means that there was a link to the worksheet or named range that was deleted.

In other words, maybe it was

=Worksheet2!A33

but Worksheet2 is deleted.

Perhaps nearby cells have similar formulas that still indicate the correct location, and you can recreate what it points to ...

Answer 2

Invalid cell reference errors occur when the spreadsheet formula contains invalid cell references.

: http://spreadsheets.about.com/od/formulatips/qt/REF_error.htm

Answer 3

, ,

 =Sheet1!A33

 =#REF!A33