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...
Given that you are pulling in SQL data I wonder if you could dramatically improve things by having the SQL also do the lookups (it's called joining). You can also join data from a SQL database with a table that is in Excel. First use Data, From Table on the table in Excel and subsequently use Data, Get Data, Combine Queries, Merge to join both the SQL and the excel table. No more lookups needed.
- 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.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.
