Comment Re: The issue isn't Excel itself... (Score 1) 187
Same. I have many workbooks with more than 10K rows feeding multiple pivot tables and they work really well. The problem is likely not the software but the implementation. Managing performance is straightforward: let Excel do most of the heavy lifting since it's always going to be faster than what you do in VBA, use memory judiciously (INDEX/MATCH instead of xLOOKUP), minimize formatting to keep things simple. Above all, have a database person look over your work before you publish if you're not that person.