Hi Frank,
Calculate is an indication that you have turned Calculation off in
Tools, options, Calculation (Tab), [X] Manual
-- and that you have something that needs to be calculated.
If that is not the problem then try
Ctrl+Alt+F9 which recalculates all cells on all worksheets in all open workbooks.
If you still have a problem show us what your formulas look like,
and an idea of how extensive they are.
--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm
"frank" wrote in message ...
I have an EXCEL workbook that for some reason does not
calculate completely. when i hit F9 for it to calculate
it takes a long time and at the bottom of the page the
word "Calculate" does not go away. any ideas?