It does a recalculate, and all of those formulas recalc at once some systems
it is fast and some slow, you can try going to options and turning off
automatic calculations, but you have to remember to calculate when you need
answers.

--
--
-John
Please rate when your question is answered to help us and others know what
is helpful.

"Marilyn" wrote in message
...
I'm currently working with an Excel 2003 file. it contains 3 sheets and
most
of the sheets contains 9424 rows of data. One sheet has the following
formulas:
=VLOOKUP(A2,V1_Forecast_Version!$A$1:$F$9241,1,0)
=VLOOKUP(A2,V1_Forecast_Version!$A$1:$F$9241,2,0)
=IF(VLOOKUP(A2,V1_Forecast_Version!$A$1:$F$9241,3, 0)="","",VLOOKUP(A2,V1_Forecast_Version!$A$1:$F$92 41,3,0))

The problem is that when I copy and paste data from one sheet to another
Excel displays Calculating Cells 5%, 10% and it takes a long time to get
to
100%. I cant do any other work while this is happening. I have been
looking
around for the answer but none of the solutions that I have seen works for
me.

Can someone please help?