I am trying to count the number of rows in excel so I can determine where I need to paste my new data. When looking at the file, I can see that there are 723 rows. However, when I count the rows (which I have used in previous workflows without issue) it is counting 1M rows.
This is a confidential workbook, so I cannot share it for your review. The sheet does have pivot tables on it, and I am not sure if that would be impacting it. I tried looping through the rows to see if they have a value in them, but it is still trying to go through the million rows and taking significantly longer than it should.
Does anyone have any ideas what may be causing this and how to resolve it?