[Solved] Recalculation

[RusselB]

Before anyone says use F9 to recalculate, I've tried that and in my situation it's not working.
I have a spreadsheet (call it A) that has cells that reference another spreadsheet file (call it B).
These cells updated when I first created A and entered the formula to reference B, the cells updated correctly.
Since then, I have made changes to B, but A isn't updating.

How can I get these cells to update properly, and, preferably, automatically?

I have tried the following:
F9 with A open and B closed (no noticeable difference)
F9 with A and B open (no noticeable difference)
Re-entering the formula originally used (keeps giving the original results)
Entering a new formula (gives new results), then re-entering the original formula (gives original results)

[squenson]

The little known trick to recalculate your cells is to press together SHIFT + CTRL + F9.

[acknak]

You might also try Edit > Links; there you can view/select/update any links to external resources.

[RusselB]

Thanks for your responses. The SHIFT + CTRL + F9 did the trick.

I also looked at the Edit > Links suggestion, which looks like it would work, but has the updating method set to Manual.
While I see an Automatic option, it's greyed out, and looking at the help file tells me that the Automatic option is only available for DDE Links.
I was unable to figure out how to make a DDE link.
Truthfully, I'm surprised that these aren't set to go automatically, or be controlled by the Recalc setting.

[m13m13]

I looked all over the 'net to find how to get a simple cell to recalculate (just a summation of the cells above), and it seems the pressing F9 or some combination of it was the most respected way to go -but it didn't work for me. Maybe because on my keyboard I have to press a "fn" button in conjuction with the numbered function buttons to get them to work instead of the various other operations they launch (toggle airplane mode, turn the speaker on or off, etc.).

Anyway, I just thought I'd note herein that what did work for me was to click on the equal sign behind the sigma character and in front of the formula input box. With the target cell selected, what it seems to do is toggle between making said cell display the value or the formula. In so doing, it made the value in the cell update.