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?

Maybe selecting all the cells
edit|Replace
what: = (equal sign)
with: = (same equal sign)
replace all

will wake up excel's calculation engine.

(changing = to = will make excel reevaluate each cell with a formula)

Adam Hollerbach wrote:

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?

--

Dave Peterson

Worked great. Thanks!

"Dave Peterson" wrote:

Maybe selecting all the cells
edit|Replace
what: = (equal sign)
with: = (same equal sign)
replace all

will wake up excel's calculation engine.

(changing = to = will make excel reevaluate each cell with a formula)

Adam Hollerbach wrote:

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?

--

Dave Peterson