cell links
 

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

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



Dan S wrote:

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

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

"Dan S" wrote in message
...
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