ghoward wrote...
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?

Does this change if you press the [Ctrl]+~ key combination? If not, is
the number format Text?