If file "A" is linked to file "B" using SUMIF function, then if file A
is sent to some one else who does not have file B. If file "A" is
opened by clicking no for update links dialog, it will show "#Value#"
in the cells linked to B. This problem is not there in Excel 97. We
have lot of files using sumif function. We are thinking of migrating to
Excel 2003. Is there any solution ?
Thanks
Diva
Bookmarks