Forum Discussion
sheet1 C5 with formula =sheet2!B2 not updating
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.
by chance are you using volatile functions like OFFSET, RAND, DATE, NOW, etc... in a lot of places or in the chain of many formula dependencies?
Also, do you notice if excel indicates it is processing in the footer bar?
