Thanks Pikus

I had already set my Calculation to automatic, but as you
point out it only recalculates after an edit or when I
press F9. what I would need is constant recalculation for
as long as I'm viewing the sheet.

Thanks



-----Original Message-----
On the main menu go to Tools--Options and go to the
Calculation tab of
the Options window that appears. Set Calculation to
Automatic. This
will not, at least not in my experience, give you
something that is
CONSTANTLY updating, but will update any time you edit
anything in the
workbook. - Pikus


---
Message posted from http://www.ExcelForum.com/

.