Link to inexistent file

[TheMadTree]

Good afternoon,

I linked a file to other files that are generated every month to gather results.
Just to make sure the formulas were working correctly I created a fake one called '9' for September (9th month).
After seeing that it works properly I deleted this fake file but the results stay. (even after forcing Excel to recalculate).

The formula I'm using is:

=IF(ISERROR('S:\OTC\Professional Customer Services\KPIs Data and Graphs\NEW 2015\NSV\Raw Data\[8.xlsx]Sheet1'!$AR$30),"",('S:\OTC\Professional Customer Services\KPIs Data and Graphs\NEW 2015\NSV\Raw Data\[8.xlsx]Sheet1'!$AR$30))

I tried changing the formula, deleting and recreating the file with the raw data but nothing works.

Can anyone help me?

Thank you

 

[Special-K99]

ISERROR(filename) isn't going to tell you if the file exists or not since that's going to be interpreted as ISERROR(string)
No connection to any file, existing or otherwise.
Looks like you need a UDF, not a native formula.

Check here for testing file existence.

Checking for the Existence of a File (Microsoft Excel)
http://www.mrexcel.com/forum/excel-questions/20797-fileexists-if-formula.html