I have a workbook that contains about 80 individual sheets, most of which are linked to each other. Whenever I change a value in a cell, the other sheets that read that cell do not change unless I double-click the cell (or hit F2) as if I were modifying the formula. After I hit enter, the cell values then change. Why won't these cells auto-calculate? (The auto-calculate option is checked under Tools>Options.) Are there too many pages or is it just an fluke? Thanks.