Comments (3)
Hi there!
First of all, thank you for using my modest solution for Excel automation.
Any special addins you using in your Excel or that file?
What happens when you manually open and update it, does update go smoothly?
Keen to try semi manual way to see if macro can actually update your file?
Something like adding Thisworkbook.RefreshAll into Workbook_Open event.
Another suggestion:
Go to Power Query options and switch off Background Data download.
^ off the top of my head. There are usually so many elements that can affect performance.
BTW, hope you using 64bit office.
Cheers,
Ivan
from power-refresh.
Thank you for the reply!
Hm, I do have the Jet Reports addin. When I open the file, it does take ~30 seconds for the data model to load fully, however after that, refreshing all goes smoothly.
That's a great idea trying the macro to see if that goes just as well as a manual run - I will report back the results of this test.
As a final try, I will disable Background Data download.
And yes indeed, 64bit all the way!
from power-refresh.
Hi IvanBond,
I love this solution. Thank you so much for sharing it. I encountered the same issue as the OP and my only workaround so far has been to create a macro to do the refresh. I set it to skip the refresh all and just set a "Macro_After" that does the refresh.
I turned off background data in Power Query and that didn't help. I'm using 64bit Excel and It's a 20mb file with 20 or so queries, lots of relationships, lots of measures and and lots of pivot tables. Takes about 12 minutes to refresh usually. Hope this helps diagnosing the problem.
Thanks again! Using a macro is not really an problem for me so I'm really pleased! Your solution helps me claim back some of my working day and use the time more effectively.
Cheers,
Nick
from power-refresh.
Related Issues (18)
- Control Number of working Excel sessions HOT 1
- Need better log for Reports Controller
- Add support for scheduling by weeks and week working days
- Add Send Email button
- Add support for vsb and bat files - run cscripts for them
- Initialize data model on wb opening (if exist)
- Add vbs for monitoring
- Improve Controller's email notifications
- Workbook password for Open / Save
- Check project with rubberduck vba
- Add triggers from MS Flow
- Add delay between updates of tracking file HOT 1
- Add Restart if Terminated option
- 64 Bit Excel HOT 2
- Terminate reports & force start cell doesn't get removed after pressing "Start Processing".
- Starter.vbs contains refer to ScriptControl
- Pivot Table Filters are being reset after refresh
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from power-refresh.