Power Query performance and open source files

Comfy

Well-known Member
Joined
Dec 21, 2009
Messages
3,376
Hi all,

I'm hoping someone has come across this and has a fix for me :)

I'm extracting data from several files, each file has the same structure and I'm pulling multiple tables (but not stored as tables) from 20+ sheets in each.

While all source files are closed the execution takes roughly:

  • 2s for one file
  • 5s for four files

However while the source files are open the execution takes roughly:
  • 2m for one file
  • 30m for four files

I can't really investigate further in work as I don't have access to download additional tools, but will try when I'm home.

Does anyone here have any advice to help point me in the right direction?
 
Last edited:

Some videos you may like

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

Comfy

Well-known Member
Joined
Dec 21, 2009
Messages
3,376
I think this is a network issue.

I placed the Source Files on a network drive and ran the query from my PC and I got a similar problem.
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,090,491
Messages
5,414,854
Members
403,549
Latest member
CascadeDiver

This Week's Hot Topics

Top