| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating Cells n% message in Status bar
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When in filter mode status bar doesn't show range of cells filted | Excel Worksheet Functions | |||
| Calculating cells | Excel Discussion (Misc queries) | |||
| How do I ignore cells with errors when calculating an average? | Excel Worksheet Functions | |||
| Help adding text values | Excel Worksheet Functions | |||
| Calculating without including Hidden Cells | Excel Discussion (Misc queries) | |||
Threaded Mode
