Worksheet is not calculating

D

David

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Referencing a cell in other worksheet that is using autofit row he 3
Inserting a new worksheet that is linked to a previous one 0
Using COUNT for text occurances in unusual worksheet? 4
Sorting with merged cells in the worksheet 1
Can I use the subtotal function while a worksheet is protected? 0
populate new "log" worksheet from invoice templates in other sheets 0
2 worksheets compare a range of data, create 3rd worksheet w/diffs 0
My Excel file is not calculating! 13

Top