Forum Discussion
Formula Help
Hello, I have tried all I know to do what I am trying, and it won't work. I could really use some help ASAP. I have a pivot table pulling off of the area in yellow and I am wanting to replace old...
Hey Joe, her worksheet has more than 400000 data rows.
And I think Excel's calculation engine is smart enough to limit the calculation to the actually used range.
HansVogelaar wrote: ``her worksheet has more than 400000 data rows``
Okay, I didn't notice. But again, 500000 or 600000 is a lot less than 1+ million.
HansVogelaar wrote: ``I think Excel's calculation engine is smart enough to limit the calculation to the actually used range.``
Then explain why =ROWS(B:B=1) in A1 in a new workbook returns 1048576.