Right now I have spreadsheet that is referencing other spreadsheets outside of the workbook. The file is not there now but when it shows up the data will update. I am using the INDIRECT.EXT function. Since nothing is there now I am receiving the #REF! error. How might I have that error disappear until the file is in its place. I assume an IF function but I don't know what notation to use to make it go away. Any help will be appreciated!