When I edit external links within excel, I end up with the link showing up as
text in the cell instead of it actually pulling information from the linked
cell. ='[Current Weekly Job Detail.xls]Sheet4'!$C$1 works fine until I
select the cell and edit it to reference Sheet5. Then I just get the formula
itself instead of the value in the linked cell.

Is there a configuration switch that causes this?

Thanks in advance
Greg