J
Jorge Rivas
if formula is: {='C:\PROJECT SHEETS 2008\[03-4590A.xls]Sheet1'!$J$5};
and you have lots of similar cells with external references and excel does not do the calculation automatically, go to Edit-Replace-> Find what: = and Replace with: =. In that way, you will force excel to replace "=" with "=", and at the same time, it will be forced to recalculate each cell.
hope this helps
and you have lots of similar cells with external references and excel does not do the calculation automatically, go to Edit-Replace-> Find what: = and Replace with: =. In that way, you will force excel to replace "=" with "=", and at the same time, it will be forced to recalculate each cell.
hope this helps