Forum Discussion
Excel Performance Issues and Errors when PC Usage is high
I have been using Excel for over 25+ years and consider myself an expert. Excel cannot handle complex formulas and big data. Even without volatile formulas Excel can't handle much of anything you thr...
You mention big data and filtering; that sounds database oriented in which case are you using Power Query and Power Pivot which were designed for that purpose? Could you actually move the data to a database? As you suggest, going beyond the point at which the workbook collapses under the weight of data is not going to be a rewarding experience.
- This data in particular is 7,400 rows and 300 Columns and in a Table.
