I have a worksheet that has several links to another file. Ineed to copy across some of those formulae to another file. When I do so, it returns a value of zero, even though the link appears to be active and both workbooks are open. Does anyone know why this might be?