Calculations from tab to tab not automatically updating
I have a large workbook with many tabs. These tabs are linked to together
throughout the tabs. Lately the cells have not been automatically changing
when the source changes. I have the automatic calculation marked in the
Options menu. F9 does not change the cell. These used to work fine but now
I have to hit F2 on the cell for it to change values.
|