Recalcualte formulas linked to other sheets (Excel 2003)

T

Theo

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
 
G

Gary''s Student

two things:

Tools > Options > Calculation and check Automatic
and then

CNTRL-ALT-F9
 
Top