Results 1 to 7 of 7

Problem when blanking out cells containing circular reference

Threaded View

Liquidus Problem when blanking out... 11-09-2011, 07:39 PM
6StringJazzer Re: Problem when blanking out... 11-09-2011, 08:53 PM
Liquidus Re: Problem when blanking out... 11-09-2011, 09:22 PM
6StringJazzer Re: Problem when blanking out... 11-09-2011, 10:49 PM
6StringJazzer Re: Problem when blanking out... 11-09-2011, 10:52 PM
Liquidus Re: Problem when blanking out... 11-10-2011, 03:11 PM
6StringJazzer Re: Problem when blanking out... 11-11-2011, 06:32 AM
  1. #1
    Registered User
    Join Date
    03-18-2011
    Location
    Berkeley, California
    MS-Off Ver
    Excel 2003
    Posts
    5

    Problem when blanking out cells containing circular reference

    Hello, I have a spreadsheet containing cells that contain a circular reference. I've also added the functionality to blank out these cells using IF(*criteria to blank*, "", *value if false*). The criteria to blank depends on a number I've entered into another cell.

    I am having a problem where if I blank out these cells, and then unblank them, I get a #VALUE! error from the cells with circular references. However, if I go back into these cells, click the formula, and press enter, the cell will fix itself and the correct number will be displayed again. If there a way I can skip doing this and have the cells automatically populate themselves? Pressing F9 does not fix this problem. Thank you.
    Last edited by Liquidus; 11-10-2011 at 03:12 PM.

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