B2 (Cell B2 on Sheet2 to return the value into a cell on sheet1) Both sheet1C5 & sheet2B2 are formatted as Currency. If I change the value of sheet2B2, it doesn’t reflect on sheet1C5. The only way I can get sheet1C5 it to show the changed value is to click on sheet1C5 ...