Highlight all the cells in that workbook and do CTRL-H (Find &
replace) Find = and replace with itself.

Hope this helps.

Pete

On Dec 11, 5:33*pm, Dave wrote:
Hello

I just deleted (delete key) data that is used by dsum and vlookup forumlas
throughout a workbook. *The formulas should be showing zero. *Instead, they
still show the answer as if the data was not deleted. *The different tabs are
not stuck in calculate mode (shows ready in lower left corner). *I tried
using F9 to force the tabs to recalculate but nothing happens. *If I place my
cursor in a cell with a formula that referenced the data and hit enter, the
formula goes to zero like it should. *I checked to make sure auto calculate
is on and it is.

What would cause this problem? *There are hundreds of formulas that
referenced this information. *It will be a major chore to go throught the
workbook and put the cursor in each cell and hit enter to zero out the
formula. *Is there a way to fix this problem? *Others within my company have
reported this problem in other files.

Any help is appreciated.

Thanks