From a suggestion, I think by Bob Phillips, I selected all cells and did a
find replace with an "=" sign.

it worked for me when nothing else did.

hth


"Robertson" wrote:

Why is my spreadsheet not updating changed formulas? The automatic
caluclation option is checked and I have tried the various ctrl+alt+F9, etc.
opthions