cell links

[Guest]

I have a spreadsheet w/ many tabs (85 or so). Recently some of the cell links
aren't updating & I have to hit F2 then enter for them to update. The
Calculation is set to automatic. Any ideas why this is happening, or more
importantly how to fix it?

Thanks,
Dan

 

[Dave Peterson]

You could try this to see if "wakes" up excel.

Select all your sheets
ctrl-a (twice in xl2003)
edit|replace
what: = (equal sign)
with: = (equal sign)
replace all

ungroup the worksheets

 

[Mirko Smilevski]

Key F9 is also for autorecalculation., try it.
smile