Forum Discussion
Recent Slowdown in Excel - SQL - PivotTable - Xlookup
Hi, At work I import data from SQL queries into Excel. Some of these data sets are up to 300k rows of data. I then link data sets with Xlookup functions and add on various other calculation into new...
Thanks for this, merging the data might help speed things up. I will have a play around with this option.
Do you happen to know if anything changed in Excel to reduce the performance, as it will be quite time consuming rebuilding all of my reports.
Do you happen to know if anything changed in Excel to reduce the performance, as it will be quite time consuming rebuilding all of my reports.
XanderT-J No I haven't heard about recent changes to the calc engine. Best if you open one such model and click Help, Feedback, I don't like something. This will send some anonymized logs to MSFT along with your complaint. If you add your email address, they may even contact you for further information.
