Thread: external links

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

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?

Excel likes to be helpful.

Try this on a new worksheet
Format A1 as a date
put =A1 in B1

format B1 as General
select B1, F2 (to edit) and hit enter.

Excel likes to help!

===
Try the same thing, but this time format A1 as Text.
Select B1, F2 (to edit) and hit enter.

B1 now has a Text format.

===
I don't think you can change excel's behavior. Just change the number format to
what you want and then F2|enter.




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?
>
> Thanks in advance
> Greg
>

--

Dave Peterson

Thanks for the help. It is tiresome but it works.

Greg


"Dave Peterson" wrote:

> Excel likes to be helpful.
>
> Try this on a new worksheet
> Format A1 as a date
> put =A1 in B1
>
> format B1 as General
> select B1, F2 (to edit) and hit enter.
>
> Excel likes to help!
>
> ===
> Try the same thing, but this time format A1 as Text.
> Select B1, F2 (to edit) and hit enter.
>
> B1 now has a Text format.
>
> ===
> I don't think you can change excel's behavior. Just change the number format to
> what you want and then F2|enter.
>
>
>
>
> 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?
> >
> > Thanks in advance
> > Greg
> >
>
> --
>
> Dave Peterson
>