Thread: Excel links to file that doesn't exist

Hi There,

I have the below link in a central excel

=IF(ISERROR('S:\International\Network Clients\[France.xls]Total Campaign'!$B$7)=TRUE,"",('S:\International\Network Clients\[France.xls]Total Campaign'!$B$7))

I have deleted the file France.xls but it still displays the old data for France.xls. I have tried refreshing, updating, changing and then changing back, but it still displays data from a file that doesn't exist.

The only thing I can think of is that because it is linking to a shared folder, the IT support system have some kind of invisible temp back up that it is extracting data from.

Any ideas/help appreciated!

Thanks

Thanks for help, but connections is empty and I can remove the links through edit links.

However, I don't want to remove the link. I need the link to still exist and show blanks numbers, as it should do because it is linking to a blank file. Really can't work out why I am having this problem as I can't think of any logical reason why it is displaying data from an old file that no longer exists...