Calculation Not Updating Between Sheets in a Worksheet

Came across a bug this afternoon. A cell to reference another worksheet wasn’t updating.

In the example below, the referenced cell was displaying $503,000, the correct amount. But the cell looking it up was displaying an old number, $1,032,000. I refreshed the worksheet a few times but couldn’t get the cell to refresh. Finally, I re-entered one of the columns in the referenced worksheet, which seemed to send the correct number back to the cell doing the referencing.

Not sure if I described that well.

D6 is $503,000.

Another sheet is set to reference D6.

But is returning a previous calculation for D6.

I finally got it to work by re-entering 30% in the above.

Thanks Daniel - Logged Issue # 004826 . Will update this space