Lately, Excel (I have excel 2003 sp2) has stopped updating links to other
excel files.

When I open the file, I get the same old message about "this document
contains links to other excel files, do you want to update" and i hit yes.
but they don't update.

I can also go to edit--links and update the links there, and still they
don't update.

The two ways I know about to make them update are going to the linked cells
and F2--enter, which gets real cumbersome real fast, and opening the source
file and recalculating, which takes a LONG time.

Is there a setting I may have accidentally tweaked to cause this problem,
and a way to get my traditional methods of updating links to work again?