Sometimes formuli in workbook don't auto update with auto-recal on
I'd try:
Select all the cells
edit|replace
what: = (equal sign)
with: =
replace all
Do it for all the sheets.
Maybe it'll wake up excel's calculation engine???
PE2 wrote:
Manual recalculate does not work. must edit formual cell to get it to recalc.
What is the fix?
--
Dave Peterson
|