Forum Discussion
sheet1 C5 with formula =sheet2!B2 not updating
In cell C5 on sheet1, I have entered =sheet2!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 that has the =sheet2!B2 formula and hit enter, then the new value of sheet2B2 will update. I have tried to turn on automatic calculations and manual and manually calculate and neither will make the sheet1C5 show the updated value from sheet2B2.
4 Replies
Please check if calculation options are in automatic mode
Yes, both sheet 1 & sheet 2 are set to auto. I have also tried to use the "calculate icon " to the right of the calculation options icon.
I was also wondering if there was a size / quantity of "sheets" that could be used. My sheet currently has over 200 "sheets" that I am calling for a value to be brought into the master sheet1 recap sheet.
The function has worked fine for over a year as my workbook has grown and I only recently noticed that it was not staying current when I was making changes to the individual sheets.
Number of sheets is limited only by available memory. At the same time with 200 sheets and bunch of formulae recalculation could take time. Of course performance depends on hardware and Excel version/platform, however quite often optimizing of data layout and cleaning of the sheets could significantly improve the performance. Above is bit abstract, but that's always on case by case.
