
Active Member

September 24, 2021

Hi I am a newbie an try to use Power Query to substitute the vlookup (sverweis) in excel.
I have a table with about 20000 (it is a join of nearly 15 tables) entries and filter/calculate them. Every time I open excel query the computer is calculating something about 5 minutes long. Is that because of the amount of entries or could I do something better.
Thanx
Jörg


Trusted Members

October 18, 2018



July 16, 2010

Hi Jorg,
You can also ensure background refresh is turned off in the query options. Query editor File tab > Options and Settings > Query Options > Current Workbook > Data Load > Background Data: deselect 'Allow data previews to download in the background'.
I don't expect this will affect the file opening time, but it should improve working in the Query Editor.
Mynda


July 16, 2010

Glad we could help 🙂
Power Pivot is the data model, so I'm not sure what you mean exactly. Perhaps this video on Power Query vs Power Pivot will help.
1 Guest(s)
