I have a summary spreadsheet that references other detail tabs. The rest of
the spreadsheet will calculate, but this summary will not. When I select the
cell, press F2, then press Enter the cell will calculate, but there has to be
an easier way than doing this a few hundred times.

The auto calculation option is selected in the options menu, so that isn't
the problem. After reading the forum a bit I have tried Ctrl+Alt+F9, and
that didn't work either?

These detail tabs are removed and replaced weekly by identically formatted
and named tabs, so I'm looking for an efficient way to help these references
find their way.

Any thoughts?