Thread: Iserror does not work for missing sheets in linked file
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.links
[email protected] BareSkrot@gmail.com is offline
external usenet poster
  
Posts: 2
Default Iserror does not work for missing sheets in linked file
Update:
Wrong example formula, the right one is of course:
IF(ISERROR(SUM('C:\Temp\otherfile.xls]sheet1'!$AT:$AT)),0,SUM('C:\Temp
\otherfile.xls]sheet1'!$AT:$AT))

Reply With QuoteReply With Quote