Can you have 200,000 rows of data in Excel? Sure! You
can have 1 million rows (I believe that's the max for Excel 2010 and newer). It's just going to take longer to get things done. You may be at the point where it's time to migrate your data set into an actual database instead of using Excel as a database server (which it isn't very good at). —
FreeMan 1 min ago