Jakub
New member
- Joined
- Mar 29, 2022
- Messages
- 2
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Excel 2016
I have an issue when I'm working with power query on excel which is using file from share drive compared to the local drive.
When using the same file but on network instead of locally the refresh time is 12 minutes vs 2. Another issue is that loading times of any step when creating query is significantly longer (15-30 minutes vs 3-4 minutes when it's using file on local drive as a source). Are there any ways to shorten that time?
When using the same file but on network instead of locally the refresh time is 12 minutes vs 2. Another issue is that loading times of any step when creating query is significantly longer (15-30 minutes vs 3-4 minutes when it's using file on local drive as a source). Are there any ways to shorten that time?