So no formulae on your worksheet or anywhere in the workbook are being
recalculated ?
Even after calling .Calculate ?

NickHK

"gilligans" wrote
in message ...

Thanks Nick,
But I am new to excel and vba. can u be little bit more specific..
I did write the following code for each sheet:

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
ActiveSheet.Calculate
End Sub

Is this right, because it is not helping...
its not recalculating..
Please correct me..


Thanks for the help.
Jyothi


--
gilligans
------------------------------------------------------------------------
gilligans's Profile:
http://www.excelforum.com/member.php...o&userid=35026
View this thread: http://www.excelforum.com/showthread...hreadid=567193