Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.links
|
|||
|
|||
Iserror does not work for missing sheets in linked file
Hello,
I have a file with links to another file. The formula I have tried is: IF(ISERROR(SUM('C:\Temp\mainfile.xls]sheet1'!$AT:$AT)),0,SUM('C:\Temp \otherfile.xls]sheet1'!$AT:$AT)) If sheet1 does not exist in the otherfile.xls, I get one of two events: 1. If otherfile.xls file is open I get the error message "Your formula contains an invalid external reference to a worksheet." 2. If otherfile.xls is closed, I get the dropdown where I can chose among the sheets in the otherfile.xls. I want the function to return a zero in case of missing sheet. Is this possible? Thanks and regards, Vegard |
#2
Posted to microsoft.public.excel.links
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In a linked calculation how do I lose the '0' in the linked file? | Excel Worksheet Functions | |||
Counting dates in multiple work sheets and work books | Excel Discussion (Misc queries) | |||
Missing linked file - can still be referenced but can't find it! | Excel Worksheet Functions | |||
#REF,ISERROR, File Not Found question. | Excel Discussion (Misc queries) | |||
ISERROR Functin to Much Work! | Excel Worksheet Functions |