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.