Closed Thread
Results 1 to 5 of 5

Circular reference error

  1. #1

    Circular reference error

    Hi all -

    I store a fomula on Formulas! to be copied to Data! at run-time.
    The formula is stored in $B1 and ref's $B1 so I get a circular ref
    error.

    What can I do?
    Thanks
    -marc


  2. #2

    Re: Circular reference error

    bump

    Any help out there please?

    Thanks
    -goss


  3. #3
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,803
    Not certain what the problem is. A function that refers to itself is certainly a circular reference. Is the function supposed to refer to itself? In cases where a circular reference is necessary, you have to enable iteration (Tools -> Options -> Calculation -> check the iteration box).

  4. #4

    Re: Circular reference error

    Hi Shorty -

    No I store the formula on a tab named formulas until at runtime the
    formula is copied to a tab named data.

    The formula is stored in cell B1 on Formula!
    It is a lookup formula with syntax =vlookup($B1,mytbl,3,false)

    So the circular ref error.

    Thanks
    -goss




    MrShorty wrote:
    > Not certain what the problem is. A function that refers to itself is
    > certainly a circular reference. Is the function supposed to refer to
    > itself? In cases where a circular reference is necessary, you have to
    > enable iteration (Tools -> Options -> Calculation -> check the
    > iteration box).
    >
    >
    > --
    > MrShorty
    > ------------------------------------------------------------------------
    > MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
    > View this thread: http://www.excelforum.com/showthread...hreadid=460233



  5. #5
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,803
    So, as I understand it: The formula is stored in "formulas" but doesn't need to do anything there. When copied to "data," it will be copied to a cell other than B1, so it doesn't create a circular reference there??

    If the formula isn't needed to do anything in "formulas," I would probably put an apostrophe at the front ('=...) so Excel will treat the cell as text rather than as a formula. Then remove the apostrophe when you copy it to "data."

Closed 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