REF Broken References

#REF! in INDEX: Row/Column index exceeds range boundaries

An #REF! error in an INDEX formula means the formula requested a row or column coordinate…

#REF! in INDIRECT: Referring to a Closed Workbook

An #REF! error produced by the INDIRECT function when pointing to another file means the target…

#REF! in INDIRECT: Sheet Name Typos and Apostrophe requirements

An #REF! error in an INDIRECT formula usually means the text string supplied to the function…

#REF! in PivotTables: When Source Range is moved or renamed

An #REF! error associated with a PivotTable indicates that the structural link between the PivotTable report…

#REF! in Named Ranges: Fixing “Refers To” errors

An #REF! error in an Excel Named Range means the cell coordinates stored in that name’s…

#REF! in Macros: Range selection on hidden sheets

In Excel VBA, attempting to execute the .Select or .Activate method on a worksheet that is…

#REF! in Linked Workbooks: Broken File Paths/Shared Drive moves

An #REF! error in a linked workbook means that Excel can no longer locate an external…

#REF! in Excel Tables: Deleting Header Rows

An #REF! error related to an Excel Table header occurs when a column header referenced by…

#REF! in OFFSET: When the offset exceeds sheet limits (Row 1,048,576)

An #REF! error in an OFFSET formula means the calculated row or column target falls outside…

#REF! in Summary Sheets: Dynamic sheet referencing failures

An #REF! error on a summary sheet occurs when dynamic consolidation formulas lose their connection to…

#REF! in VLOOKUP: When col_index_num exceeds Table Array

When a VLOOKUP function returns a #REF! error, it is almost exclusively due to a mismatch…

#REF! after Deleting Source Rows or Columns

Deleting a row or column that is explicitly referenced in an Excel formula is the most…