Please Help! Cells not updating...

[Guest]

My links to cells in other worksheets within a workbook don't appear to be
updating
unless I close the workbook and re-open it. Automatic calculation is turned
on and F9 doesn't appear to do the trick. What could be causing this?

Background: The workbook is large with 100's of tabs and many thousands of
formulas. One trick that seemed to work on individual tabs was to do a
global find and replace of "=" with "=". Is there a better way??

 

[DaveO]

Try forcing an absolute recalculation of a spreadsheet by
simultaneously pressing CTRL-ALT-F9.

In the latest version of Excel you can rebuild the entire
recalculation tree: press CTRL-ALT-SHIFT-F9. This should be necessary
only once (if you save the rebuilt sheet).

Let us know if that does it!
Dave O

 

[DaveO]

I responded to this earlier but I don't see my post, so here goes:

To force an absolute recalculation of a spreadsheet, simultaneously
press CTRL-ALT-F9.

In the latest version of Excel you can rebuild the entire
recalculation tree press CTRL-ALT-SHIFT-F9. This should be necessary
only once (if you save the rebuilt sheet).

 

[Dave Peterson]

Maybe you could do this:

select all the worksheets
select a single cell
edit|Replace
what: = (equal sign)
with: =
replace all
Ungroup the sheets