If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Worksheet is not calculating
Hi There,
I have a worksheet using the following equation several hundred times. The worksheet is about 700 rows and pulling from 2 worksheets in the same workbook (pulling from a range of 4,000 rows). All the calculations work great however when I try to duplicate the same worksheet, with these equations, when I get over 6 duplicate worksheets excel notes that the worksheet still needs to calculate. I have tools set to automatically recalculate. And when I press F9 it still says the sheet needs to calculate. What is causing this? Is the repetition of the calculation too many times too much for the file? =ROUND(SUMPRODUCT(--(WTB!$F$460:$F$4411=$F$2),--(WTB!$I$460:$I$4411=$A454),WTB!Q$460:Q$4411)/1000,0) Thanks for your help! |
Thread Tools | |
Display Modes | |
|
|