L
Larry
I have made changes to one tab of a workbook. Another tab
of this workbook references the other tab where the change
was made. However, the new result is not being shown in
the second tab. Instead, it shows the previous result.
Automatic recalculation for the entire workbook is on. Is
there any reason why the formulas are not being updated?
The only way I can get them to update is to edit the cell
and then hit enter. The correct result is then populated.
This file contains many tabs (about 40 or so) and is about
2MB in size. This problem is quite worrisome in that I
don't trust the results I am seeing.
Thanks.
of this workbook references the other tab where the change
was made. However, the new result is not being shown in
the second tab. Instead, it shows the previous result.
Automatic recalculation for the entire workbook is on. Is
there any reason why the formulas are not being updated?
The only way I can get them to update is to edit the cell
and then hit enter. The correct result is then populated.
This file contains many tabs (about 40 or so) and is about
2MB in size. This problem is quite worrisome in that I
don't trust the results I am seeing.
Thanks.