Check this list:

http://xldynamic.com/source/xld.xlFAQ0024.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Leesa" wrote in message
...
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.