Hi Kiran,


You dont have to close the work sheet and open it again, what you can
do is save the work sheet when ever you want to view the changes made
by other user, clt+s acts as refresh.

hope this helps

digvijay


--
parmar21
------------------------------------------------------------------------
parmar21's Profile: http://www.excelforum.com/member.php...fo&userid=8006
View this thread: http://www.excelforum.com/showthread...hreadid=378893