Recalcualte formulas linked to other sheets (Excel 2003)
 

Hi,

I've got a consoldiated worksheet which gets it's data from 2 other
worksheets. Only when I'm in a cell and do the F2 - Enter thing, I get a
re-calculation.

So F9 doesn't help.

How can I get the re-calculations done (too many cells for the F2 + Enter
thing).

Theo

Recalcualte formulas linked to other sheets (Excel 2003)
 

two things:

Tools Options Calculation and check Automatic
and then

CNTRL-ALT-F9
--
Gary''s Student - gsnu200765


"Theo" wrote:

Hi,

I've got a consoldiated worksheet which gets it's data from 2 other
worksheets. Only when I'm in a cell and do the F2 - Enter thing, I get a
re-calculation.

So F9 doesn't help.

How can I get the re-calculations done (too many cells for the F2 + Enter
thing).

Theo

Recalcualte formulas linked to other sheets (Excel 2003)
 

Sorry, doesn't do the thing!

"Gary''s Student" wrote:

two things:

Tools Options Calculation and check Automatic
and then

CNTRL-ALT-F9
--
Gary''s Student - gsnu200765


"Theo" wrote:

Hi,

I've got a consoldiated worksheet which gets it's data from 2 other
worksheets. Only when I'm in a cell and do the F2 - Enter thing, I get a
re-calculation.

So F9 doesn't help.

How can I get the re-calculations done (too many cells for the F2 + Enter
thing).

Theo