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