Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro help | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
up to 7 functions? | Excel Worksheet Functions | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |