+ Reply to Thread
Results 1 to 4 of 4

External Link Shows Formula Not Info

  1. #1
    Registered User
    Join Date
    12-03-2005
    Posts
    2

    External Link Shows Formula Not Info

    I apologize iof this is answered somewhere already, but I can't find it.

    I'm using the info in a worksheet to populate the cells in another. I use the appropriate formula to reference the worksheet ie. =Sheet1!A46. It works in some cells but in others it simply displays the formula itself. The cells are formatted the same whether it be text, number, currency, etc.

    Any ideas would be greatly appreciated.

  2. #2
    Biff
    Guest

    Re: External Link Shows Formula Not Info

    Hi!

    Those cells are formatted as text.

    Select the cells in question
    Goto Format>Cells>Number>GENERAL>OK

    With those cells still selected
    Goto Edit>Replace
    Find what: =
    Replace with: =
    Replace All

    Biff

    "nia" <nia.1zhscm_1133660402.4218@excelforum-nospam.com> wrote in message
    news:nia.1zhscm_1133660402.4218@excelforum-nospam.com...
    >
    > I apologize iof this is answered somewhere already, but I can't find
    > it.
    >
    > I'm using the info in a worksheet to populate the cells in another. I
    > use the appropriate formula to reference the worksheet ie.
    > =Sheet1!A46. It works in some cells but in others it simply displays
    > the formula itself. The cells are formatted the same whether it be
    > text, number, currency, etc.
    >
    > Any ideas would be greatly appreciated.
    >
    >
    > --
    > nia
    > ------------------------------------------------------------------------
    > nia's Profile:
    > http://www.excelforum.com/member.php...o&userid=29334
    > View this thread: http://www.excelforum.com/showthread...hreadid=490482
    >




  3. #3
    Registered User
    Join Date
    12-03-2005
    Posts
    2

    I knew It Had To Be A Simple Thing!

    Thank you so much! this has been bugging me for months. Thanks so much! What a great forum. I'm sure I'll be back.

  4. #4
    Biff
    Guest

    Re: External Link Shows Formula Not Info

    >this has been bugging me for months.

    Don't wait so long the next time you have a question or problem!

    Thanks for the feedback!

    Biff

    "nia" <nia.1zhtqo_1133662206.2063@excelforum-nospam.com> wrote in message
    news:nia.1zhtqo_1133662206.2063@excelforum-nospam.com...
    >
    > Thank you so much! this has been bugging me for months. Thanks so much!
    > What a great forum. I'm sure I'll be back.
    >
    >
    > --
    > nia
    > ------------------------------------------------------------------------
    > nia's Profile:
    > http://www.excelforum.com/member.php...o&userid=29334
    > View this thread: http://www.excelforum.com/showthread...hreadid=490482
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1